Oracle11g GoldenGate配置错误OGG-00868 Attaching to ASM server

最新推荐文章于 2024-08-27 15:19:52 发布

转载最新推荐文章于 2024-08-27 15:19:52 发布 · 656 阅读

文章标签：

本文介绍了如何解决Oracle GoldenGate (OGG) 在连接ASM时出现的ORA-12154错误。主要通过修改EXTRACT参数配置、listener.ora和服务描述符文件tnsnames.ora来实现正确连接。适用于遇到类似问题的技术人员参考。

部署运行你感兴趣的模型镜像

GGSCI (CBDBS01) 9> start eiexaa
错误：
2011-02-24 10:32:45 ERROR OGG-00868 Oracle GoldenGate Capture for Oracle, eiexaa.prm: Attaching to ASM server CBOMS:1568/+ASM1: (12154) ORA-12154: TNS:could not resolve the connect identifier specified.
2011-02-24 10:32:45 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eiexaa.prm: PROCESS ABENDING.
修改下面的
1、
EXTRACT eiexAA
USERID ggtransfer,password ggtransfer
TRANLOGOPTIONS ASMUSER SYS@CBOMS:1568/+ASM1,ASMPASSWORD oracle
EXTTRAIL ./dirdat/dd
DDL
TABLE test.*;
改成
EXTRACT eiexAA
USERID ggtransfer,password ggtransfer
TRANLOGOPTIONS ASMUSER SYS@ASM1,ASMPASSWORD oracle
EXTTRAIL ./dirdat/dd
DDL
TABLE test.*;

2、在rac的节点改listener.ora
SID_LIST_LISTENER =
    (SID_LIST =
      (SID_DESC =
         (SID_NAME = PLSExtProc)
         (ORACLE_HOME = /oracle/crs_home/product/11.2.0/grid)
         (PROGRAM = extproc)
      )
      (SID_DESC =
          (GLOBAL_NAME = ASM)
          (ORACLE_HOME = /oracle/crs_home/product/11.2.0/grid)
          (SID_NAME=+ASM1)
      )
   )

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1.1)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1.2)(PORT = 1521))
    )
)

3、在rac的节点加上tnsnames.ora
ASM1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1.1)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)
      (UR=A)
     )
)

ASM2 =
   (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1.2)(PORT = 1521))
         (CONNECT_DATA =
         (SERVER = DEDICATED)
         (SERVICE_NAME = ASM)
         (INSTANCE_NAME = +ASM2)
(UR=A)
      )
   )

1、在客户端的tnsnames.ora加上
ASM1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.1.1)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ASM)
      (INSTANCE_NAME = +ASM1)
      (UR=A)
     )
)