GoldenGate Data Pump进程report报WARNING OGG-01223 Cannot find executable file './server'无法启动解决

?

今天遇到一怪问题，纳服的哥们又打过来说我们的 data pump 进程没启动，导致数据无法同步到对端，

因为以往 data pump 进程没启动原因很简单，总是报 WARNING OGG-01223 TCP/IP error 146 (Connection refused).?

出现这种错误，要么是因为网络不通，要么是因为对端的 manager 进程未启动。

和纳服哥们一起核实后发现该对端进程正常运行，且网络也是通的，自己还不信，登上对端的机器发现，的确如其所说。

尝试重启本地的 data pump 进程发现，进程的 lag 只增不减，进程 report 和 ggserr 日志中不断输出

WARNING OGG-01223 ?Cannot find executable file './server'. 错误信息

?

GGSCI (bjyschxzg1) 4> view report PZJ_NF1

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

2013-06-19 00:01:30 ?WARNING OGG-01223 ?Cannot find executable file './server'.

?

bjyschxzg1:/home/oracle/ggs$tail -f ggserr.log

2013-06-19 00:15:47 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:47 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:47 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:47 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:47 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:48 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:48 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

2013-06-19 00:15:48 ?WARNING OGG-01223 ?Oracle GoldenGate Capture for Oracle, pzj_nf6.prm: ?Cannot find executable file './server'.

?

GoldenGate 中 Data Pump 进程只负责将 redo 数据流传输到 target 端，并不负责将 redo 数据流写入 target 的本地磁盘文件，这部分工作是由

target 端的 mgr 进程自动启动的 collector 进程负责。

官方文档如下描述 collector 进程：

The Collector process operates on the target system to receive incoming data and write it to the trail.

Dynamic Collector

Typically, Oracle GoldenGate users do not interact with the Collector process. It is started

dynamically by the Manager process. This is known as a dynamic collector.

Static Collector

You can run a static Collector manually by running the SERVER program at the command

line with the following syntax and input parameters as shown:

server [] [...]

?

由于我们的环境中都是使用动态的 collector，正常情况下 mgr 启动时会调用 ggs 实例的 home 目录下的 server 二进制文件启动 collector 进程。

?

ggs home 下的 server 二进制文件

bjyscsjqz:/home/oracle/ggs$ls -lt server

-rwxr-x---. 1 oracle oinstall 13757119 Aug 24 ?2012 server

?

mgr 调用 ggs home 下的 server 二进制文件启动的 collector 进程

localhost.localdomain:/home/oracle$ps -ef | grep goldengate | grep -v grep | grep server

oracle ? 11035 10883 ?0 11:00 ? ? ? ? ?00:00:02 ./server -w 300 -p 7815-8000 -m 7809 -k -l /goldengate/ggs/ggserr.log

?

登录目标端的纳服 数据库主机发现目标端的 ggs home下无该 server 二进制文件