oracle 11gR2 配置goldengate连接asm实例

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:35

oracle 11gR2 配置goldengate连接asm实例

grid用户 listener.ora文件
[db13:grid]more listener.ora
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = /software/grid/product/11.2.0)
(SID_NAME = +ASM2)
)
)
[db13:grid]

oracle用户tnsnames.ora
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM2)
)
)

oracle用户测试
tnsping asm

goldengate extract 写法:
[i]TRANLOGOPTIONS ASMUSER SYS@asm,[i]ASMPASSWORD password

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】