Goldengate Data Pump Process report warning OGG-01223 cannot find Executable File './Server restart

Today, we encountered a strange problem. The na server's buddy called to say that our data pump process was not started, and the data could not be synchronized to the peer end,
Since the previous data pump process does not start the reason is very simple, always reported warning OGG-01223 TCP/IP error 146 (connection refused ).
This error occurs either because the network is disconnected or because the peer Manager process is not started.
After checking with the NA server buddy, I found that the peer process was running normally and the network was also accessible. I did not believe it, but I did find it on the opposite machine, as I said.
Restart the local data pump process and find that the lag of the process only increases or decreases, and the process reports and ggserr logs are continuously output.
Warning OGG-01223 cannot find Executable File './Server'. error message

Ggsci (bjyschxzg1) 4> View Report pzj_nf1
00:01:30 warning OGG-01223 cannot find Executable File './Server '.
00:01:30 warning OGG-01223 cannot find Executable File './Server '.
00:01:30 warning OGG-01223 cannot find Executable File './Server '.
00:01:30 warning OGG-01223 cannot find Executable File './Server '.
00:01:30 warning OGG-01223 cannot find Executable File './Server '.
00:01:30 warning OGG-01223 cannot find Executable File './Server '.

Bjyschxzg1:/home/Oracle/GGS $ tail-F ggserr. Log
00:15:47 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:47 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:47 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:47 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:47 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:48 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:48 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.
00:15:48 warning OGG-01223 Oracle goldengate capture for Oracle, pzj_nf6.prm: cannot find Executable File './Server '.

The Data Pump process in goldengate is only responsible for transmitting the redo data stream to the target end, and is not responsible for writing the redo data stream to the target's local disk file.
The target Mgr process automatically starts the collector process.
The official documentation describes the collector process as follows:
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 <parameter> [<parameter>] [...]

Since dynamic collector is used in our environment, under normal circumstances, when Mgr starts, it will call the server binary file in the home directory of the GGS instance to start the collector process.

Server binary file in GGS home
Bjyscsjqz:/home/Oracle/GGS $ LS-lt Server
-Rwxr-x ---. 1 Oracle oinstall 13757119 Aug 24 2012 Server

Mgr calls the collector process started by the server binary file under GGS home
Localhost. localdomain:/home/Oracle $ PS-Ef | grep goldengate | grep-V grep | grep Server
Oracle 11035 10883 0? 00:00:02./Server-W 300-P 7815-8000-M 7809-K-l/goldengate/GGS/ggserr. Log

Log on to the target client's Server Database Host and find that the target GGS home does not have the server binary file.
Bjyscnfdbnfzc01:/home/Oracle/GGS $ LS-lt Server
Ls: cannot access server: no such file or directory

At the same time, although the Mgr process has been started, the collector process has not actually started. This is why the Data Pump process at the source end reports an error and suspends.
Bjyscnfdbnfzc01:/home/Oracle/GGS $ PS-Ef | grep goldengate
Oracle 29790 28264 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? 00:00:01/Oracle/oradata4/goldengate/extract paramfile/Oracle/oradata4/goldengate/dirprm/mongoreportfile/Oracle/oradata4/goldengate/dirrpt/mongoprocessid extzj_mh usesubdirs
Oracle 29803 29790 0? 00:00:01/Oracle/oradata4/goldengate/extract paramfile/Oracle/oradata4/goldengate/dirprm/mongoreportfile/Oracle/oradata4/goldengate/dirrpt/mongoprocessid pmpzj_mh usesubdirs
Oracle 29807 29790 0? 00:00:08/Oracle/oradata4/goldengate/replicat paramfile/Oracle/oradata4/goldengate/dirprm/mongoreportfile/Oracle/oradata4/goldengate/dirrpt/mongoprocessid rzj_nf1 usesubdirs
Oracle 29812 29790 0? 00:00:03/Oracle/oradata4/goldengate/replicat paramfile/Oracle/oradata4/goldengate/dirprm/mongoreportfile/Oracle/oradata4/goldengate/dirrpt/mongoprocessid rzj_nf6 usesubdirs
Oracle 31564 31146 0 00:00:00 pts/2 grep goldengate

To solve this problem, the reason for MOS [ID 1550203.1] is described as follows:

Cause
Message cocould be caused
-"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 13619841 Apr 3 23:32 Server
2. Stop/start goldengate manager on target environment

3. Start Remote Data Pump extract (s ).

For reprinting, please indicate the author's source and original article links; otherwise, you will be held legally responsible:

Author: xiangsir

Link: http://blog.csdn.net/xiangsir/article/details/9122057

QQ: 444367417

MSN: xiangsir@hotmail.com