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

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)
    )
  )
 

 oracle用户测试

tnsping  asm

 

 

goldengate extract 写法：

TRANLOGOPTIONS ASMUSER SYS@asm,ASMPASSWORD  password

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-709983/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-709983/