GoldenGate Data Pump进程report报WARNING OGG-01223 Cannot find executable file './server'无法启动解决(二)
e/ggs$ls -lt server
ls: cannot access server: No such file or directory
同时尽管 mgr 进程已经启动,但实际并未启动 collector 进程,这就是源端的 data pump 进程报错并挂起的原因。
bjyscnfdbnfzc01:/home/oracle/ggs$ps -ef | grep goldengate
oracle 29790 28264 34 15:34 00:09:27 ./mgr PARAMFILE /oracle/oradata4/goldengate/dirprm/mgr.prm REPORTFILE /oracle/oradata4/goldengate/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
oracle 29794 29790 0 15:34 00:00:01 /oracle/oradata4/goldengate/extract PARAMFILE /oracle/oradata4/goldengate/dirprm/extzj_mh.prm REPORTFILE /oracle/oradata4/goldengate/dirrpt/EXTZJ_MH.rpt PROCESSID EXTZJ_MH USESUBDIRS
oracle 29803 29790 0 15:34 00:00:01 /oracle/oradata4/goldengate/extract PARAMFILE /oracle/oradata4/goldengate/dirprm/pmpzj_mh.prm REPORTFILE /oracle/oradata4/goldengate/dirrpt/PMPZJ_MH.rpt PROCESSID PMPZJ_MH USESUBDIRS
oracle 29807 29790 0 15:34 00:00:08 /oracle/oradata4/goldengate/replicat PARAMFILE /oracle/oradata4/goldengate/dirprm/rzj_nf1.prm REPORTFILE /oracle/oradata4/goldengate/dirrpt/RZJ_NF1.rpt PROCESSID RZJ_NF1 USESUBDIRS
oracle 29812 29790 0 15:34 00:00:03 /oracle/oradata4/goldengate/replicat PARAMFILE /oracle/oradata4/goldengate/dirprm/rzj_nf6.prm REPORTFILE /oracle/oradata4/goldengate/dirrpt/RZJ_NF6.rpt PROCESSID RZJ_NF6 USESUBDIRS
oracle 31564 31146 0 16:01 pts/2 00:00:00 grep goldengate
针对这个问题,MOS 文章 [ID 1550203.1] 对其原因描述如下:
Cause
message could be caused by
- "server" binary in TARGET $GG_HOME is missing or has the incorrect permissions
- GoldenGate manager in TARGET environment is unable to launch new server collector processes (hung process)
Solution
1. Check "server" binary is located in TARGET $GG_HOME and with correct permissions like:
[ogg@gglnx1 gg]$ ls -lrt server
-rwxr-x---. 1 ogg ogg 13619841 Apr 3 23:32 server
2. Stop/start GoldenGate manager on TARGET environment
3. Start remote Data Pump Extract(s).