GoldenGate Data Pump Process report WARNING OGG-01223 Cannot find e

Source: Internet
Author: User

The GoldenGate Data Pump Process report the WARNING OGG-01223 Cannot find executable file '. /Server' cannot be started to solve a strange problem today. 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. Try to restart the local data pump process found that the process of lag only increase not decrease, the Process report and ggserr logs continuously output WARNING OGG-01223 Cannot find executable file '. /server '. error message GGSCI (bjyschxzg1) 4> view report PZJ_NF12013-06-19 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 '. 2013 -06-19 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. log2013-06-19 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: 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 '. 2013-06-19 00:15:48 WARNING OG G-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, this is the responsibility of the collector process automatically started by the mgr process on the target. 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 CollectorTypically, Oracle GoldenGate users do not interact with the Collector process. it is starteddynamically by the Manager process. this is known as a dynamic collector. static CollectorYou can run a static Collector manually by running the SERVER program at the c Ommandline 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. Bjyscsjqz:/home/oracle/ggs $ ls-lt server-rwxr-x ---. 1 oracle oinstall 13757119 Aug 24 2012 server mgr calls the collector process localhost started by the server binary file under ggs home. localdomain:/home/oracle $ ps-ef | grep goldengate | grep-v grep | grep serveroracle 11035 10883 0? 00:00:02. /server-w 300-p 7815-8000-m 7809-k-l/goldengate/ggs/ggserr. log on to the target server, log on to the target server, and check that the target ggs home does not have the server binary file bjyscnfdbnfzc01:/home/oracle/ggs $ ls-lt serverls: cannot access server: no such file or directory at the same time, although the mgr process has been started, but the collector process is not actually started, this is the reason why the data pump process at the source end reports an error and hangs. Bjyscnfdbnfzc01:/home/oracle/ggs $ ps-ef | grep goldengateoracle 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 USESUBDIRSoracle 29803 29790? 00:00:01/oracle/oradata4/goldengate/extract PARAMFILE/oracle/oradata4/goldengate/dirprm/mongoreportfile/oracle/oradata4/goldengate/dirrpt/mongoprocessid USESUBDIRSoracle 29807 29790? 00:00:08/oracle/oradata4/goldengate/replicat PARAMFILE/oracle/oradata4/goldengate/dirprm/mongoreportfile/oracle/oradata4/goldengate/dirrpt/mongoprocessid USESUBDIRSoracle 29812 29790? 00:00:03/oracle/oradata4/goldengate/replicat PARAMFILE/oracle/oradata4/goldengate/dirprm/mongoreportfile/oracle/oradata4/goldengate/dirrpt/mongoprocessid USESUBDIRSoracle 31564 0/pts/ 2 00:00:00 grep goldengate to address this problem, the reason for MOS [ID 1550203.1] is described as follows: causemessage cocould 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 13619841 Apr 3 23:32 server2. Stop/start GoldenGate manager on TARGET environment3. Start remote Data Pump Extract (s ).

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.