在配置goldengate的时候,我们需要连接asm实例,配置方法如下:oracle 10g rac的方法:在本地rac两个节点上listener.ora文件中添
在配置goldengate的时候,我们需要连接asm实例,,配置方法如下:
oracle 10g rac的方法:
在本地rac两个节点上listener.ora文件中添加:
rac1节点:
(sid_desc =
(global_name = asm)
(oracle_home = /oracle/app/product/10.2.0/db_1)
(sid_name = +asm1)
)
)
rac2节点:
(sid_desc =
(global_name = asm)
(oracle_home = /oracle/app/product/10.2.0/db_1)
(sid_name = +asm2)
)
)
在本地rac两个节点和远程客户端的tnsnames.ora文件中添加:
asm2 =
(description =
(address = (protocol = tcp)(host = 192.168.10.12)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = asm)
(instance_name = +asm2)
(ur = a)
)
)
asm1 =
(description =
(address = (protocol = tcp)(host = 192.168.10.11)(port = 1521))
(connect_data =
(server = dedicated)
(service_name = asm)
(instance_name = +asm1)
(ur = a)
)
)
然后重启监听,远程测试连接:
[oracle@target ~]$ sqlplus /as sysdba
sql*plus: release 10.2.0.4.0 - production on wed oct 19 05:17:20 2011
copyright (c) 1982, 2007, oracle. all rights reserved.
connected to:
oracle database 10g enterprise edition release 10.2.0.4.0 - production
with the partitioning, olap, data mining and real application testing options
sql> connsys/sys@asm1 as sysdba;
connected.
更多oracle相关信息见oracle 专题页面 ?tid=12