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 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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle ASM 配置錯誤OracleASM
- GoldenGate 常見錯誤分析(二)Go
- goldengate + asm + racGoASM
- 急 !!SQL SERVER錯誤SQLServer
- 使用goldengate error log檢視錯誤資訊GoError
- Oracle goldengate 11g 錯誤彙總OracleGo
- SQL Server的“錯誤:9004”SQLServer
- SQL Server 錯誤日誌SQLServer
- oracle 11gR2 配置goldengate連線asm例項OracleGoASM
- oracle11g gateway for sql server2005配置OracleGatewaySQLServer
- SQL server錯誤:53和 SQL server錯誤:17 ,小樣你在劫難逃SQLServer
- DB2 DDL操作引起的GoldenGate錯誤DB2Go
- ubuntu sudoers配置錯誤Ubuntu
- SQL Server 容易忽略的錯誤SQLServer
- Microsoft SQL Server,錯誤: 20582ROSSQLServer
- ORACLE11G解決ORA-00845錯誤Oracle
- HTTP 錯誤 500.19- Internal Server Error 錯誤解決方法HTTPServerError
- Oracle 高可用 goldengate 11g 錯誤彙總OracleGo
- Oracle GoldenGate導致IMP出現ORACLE 32588錯誤OracleGo
- goldengate命令輸入錯誤導致的血案2Go
- Goldengate複製程式錯誤Fatal error executing DDLGoError
- 安裝oracle11g遇到的Oracle11g Error in invoking target類錯誤OracleError
- Mabatis配置錯誤日誌BAT
- IOS 配置錯誤的BUGiOS
- HTTP 錯誤 500.19 - Internal Server ErrorHTTPServerError
- SQL Server ErrorLog 錯誤日誌SQLServerError
- Oracle11g新增密碼錯誤延遲驗證Oracle密碼
- ORACLE11G ORA-600[kkdcacr ptn_kxcp]錯誤Oracle
- oracle ASM錯誤Initializing the Oracle ASMLib driver:[FAILED]OracleASMAI
- DBV驗證ASM裡的datafile,出現錯誤ASM
- Goldengate 基本配置Go
- oracle goldengate 配置OracleGo
- SQL Server DACPAC資料庫部署錯誤SQLServer資料庫
- SQL SERVER Msg 7357錯誤解決SQLServer
- ORACLE11g DataGuard手工建立錯誤的解決方案(一)Oracle
- ORACLE11g DataGuard手工建立錯誤的解決方案(二)Oracle
- Linux下安裝oracle11g和錯誤詳解LinuxOracle
- oracle dataguard 配置錯誤彙總Oracle