怎么固定连接一个实例 现在在SYSTEM用户下面有个存储过程,希望让它只在某一个实例中运行,怎么办?最好是能写在存储过程里面执行的语句.因为在集群(RAC)环境下.有多个实例. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 使用pl/sql 选中此存贮过程进行edit, copy语句,conn 用户名/密码@string_other_server;粘贴上语句,编译,即可。 修改连接的服务名配置即可,如把以下的自动选择实例连接ora10 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.36)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.37)(PORT = 1521)) (LOAD_BALANCE = yes) (FAILOVER = YES) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora10) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )改为:ora10 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.36)(PORT = 1521)) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora10) ) ) 再写个存储过程,存储过程调用你的存储过程前,判断是那个instance,如果不对就不执行。.... v_instance varchar2(100);begin select INSTANCE_NAME into v_instance from v$instance ; if v_instance='指定的实例' then yourProcedure; else dbms_output.put_line('不是指定的实例'); end if;end;/ 连接时使用instance_name就可以了.不要指定db_name,, 否则如果配置了load balance的话,就有可能连接到另一实例了.指定rac1就可以 oracle 行转列问题 关于组合索引 写个查询语句取出从2008年到当前年 ORA-01445: cannot select ROWID from, or sample, a join view without a key-preser ORACLE中触发器的问题 Win7+Oracle8.1.7客户端+PL/SQL7.0 中文竖排问题如何解决? oracle 急:映射数据库以外XML文档的办法 安装问题1 oracle 查询报错,单行子查询返回多个行 在异地的两个oracle数据库如何实现同步更新、插入、修改、册除、表结构,单向,双向修改都行?? 请教PLSQL语句的2个小程序
conn 用户名/密码@string_other_server;
粘贴上语句,编译,即可。
ora10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.36)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.37)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = YES)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
改为:
ora10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.211.200.36)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora10)
)
)
....
v_instance varchar2(100);
begin
select INSTANCE_NAME into v_instance from v$instance ;
if v_instance='指定的实例' then
yourProcedure;
else
dbms_output.put_line('不是指定的实例');
end if;
end;
/