Oracle11g GoldenGate配置錯誤OGG-00868 Attaching to ASM server

mengzhaoliang發表於2011-02-24

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 oracle
EXTTRAIL ./dirdat/dd
DDL
TABLE test.*;
改成
EXTRACT eiexAA
USERID ggtransfer,password ggtransfer
TRANLOGOPTIONS ASMUSER 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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章