在配置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)
(I