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).