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

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

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

可以使用plsql连接上远程数据库的实例

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

转载于:http://blog.itpub.net/12778571/viewspace-687844/