oracle11g ogg报价,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的節(jié)點改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的節(jié)點加上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連接上遠程數(shù)據(jù)庫的實例
總結(jié)
以上是生活随笔為你收集整理的oracle11g ogg报价,Oracle11g GoldenGate配置错误OGG-00868 Attaching to ASM server的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。
- 上一篇： 支付宝v1v2v3各代表什么
- 下一篇： c语言输入字符时控制符%c前加空格的原因