oracle 11gR2 配置goldengate连接asm实例
grid用户 listener.ora文件
[nhdb13: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
[nhdb13: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)
)
)
[nhdb13:grid]
oracle用户tnsnames.ora
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM2)
)
)
asm =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db13)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM2)
)
)
oracle用户测试
tnsping asm
goldengate extract 写法：
TRANLOGOPTIONS ASMUSER SYS@asm,ASMPASSWORD password
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7199859/viewspace-709983/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
有什么样的心态就有什么样的人生
请登录后发表评论
登录
全部评论
最新文章
- 《手把手教你用AI安装Oracle 19c（附详细步骤）》
- 《3小时手工安装Oracle，用AI只需15分钟》
- oracle 20c 不支持non-cdb架构
- 当删除oracle数据库user时发生row cache lock 等待事件
- 通过 Oracle_Cloud_Infrastructure oci 云认证考试
- ORA-32021: parameter value longer than 255 characters 解决方法
- online清理oracle 监听日志推荐的做法
- 分享查看统计信息非常好的脚本
- impdp 导入 schema的数据时会自动创建对应的用户
- 如何移动asm磁盘组内的数据文件到另外一个磁盘组
