—配置抽取进程后
启动进程后报错:
2018-06-08 21:48:42 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EORA01 starting.
2018-06-08 21:48:42 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora01.prm: EXTRACT EORA01 starting.
2018-06-08 21:48:42 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, eora01.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2018-06-08 21:48:43 ERROR OGG-00664 Oracle GoldenGate Capture for Oracle, eora01.prm: OCI Error during OCIServerAttach (status = 12545-Error while trying to retrieve text for error ORA-12545).
2018-06-08 21:48:44 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eora01.prm: PROCESS ABENDING.
一看就是监听方面的问题:ORA-12545,但是监听都是正常的。这种错误绝大部分都是由于抽取进程的配置错误导致进程无法启动的。解决方法就是一个一个的检查的配置,终于看到了ORACLE_HOME不对,应该是db_1而不是dbhome_1,修改后就正常启动了。
GGSCI (cndba) 7> view params eora01
extract eora01
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
setenv (ORACLE_SID=orcl)
setenv (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
userid gate01, password gate01
exttrail /u01/app/oracle/ogg/dirdat/et
table gate01.*;
GGSCI (cndba) 8> start eora01
Sending START request to MANAGER ...
EXTRACT EORA01 starting
GGSCI (cndba) 9> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EORA01 00:00:00 00:00:07
正常了。
版权声明:本文为博主原创文章,未经博主允许不得转载。
OGG-00664