揭示OGG DataPump进程和Server进程运行原理的几篇文章

来源：互联网发布：python config 编辑：程序博客网时间：2024/06/15 17:08

揭示OGG DataPump进程和Server进程运行原理的几篇文章:

Pump extract abend- OGG-01224 TCP/IP error 111 (Connection refused), endpoint: <hostname>:7809 (Doc ID 2139900.1)
pump abends when target manager shows: OGG-00975 start_collector failed. (Doc ID 1961885.1)
Starting collector fails with OGG-01117 (Doc ID 2105074.1)

做实验验证:

之前该目的端os是关闭的.os上没有配置开机自动拉起ogg.如下是在目的端执行start mgr命令之后的 tail -f ggserr.log:2017-03-29 00:24:25  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start mgr.2017-03-29 00:24:25  WARNING OGG-01877  Oracle GoldenGate Manager for Oracle, mgr.prm:  Missing explicit accessrule for server collector.2017-03-29 00:24:25  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #8).2017-03-29 00:24:25  INFO    OGG-00983  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started (port 7809).2017-03-29 00:24:27  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from EXTRACT on host [192.168.80.81]:49232 (START SERVER CPU -1 PRI -1  TIMEOUT 300 PARAMS ).2017-03-29 00:24:27  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #5).2017-03-29 00:24:27  INFO    OGG-01677  Oracle GoldenGate Collector for Oracle:  Waiting for connection (started dynamically).2017-03-29 00:24:27  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from SERVER on host [::1]:43682 (REPORT 2500 7819).2017-03-29 00:24:27  INFO    OGG-00960  Oracle GoldenGate Manager for Oracle, mgr.prm:  Access granted (rule #1).2017-03-29 00:24:27  INFO    OGG-00974  Oracle GoldenGate Manager for Oracle, mgr.prm:  Manager started collector process (Port 7819).2017-03-29 00:24:27  INFO    OGG-01228  Oracle GoldenGate Collector for Oracle:  Timeout in 300 seconds.2017-03-29 00:24:32  INFO    OGG-01229  Oracle GoldenGate Collector for Oracle:  Connected to :49233.2017-03-29 00:24:32  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u02/ggs/dirdat/td000000 (byte -1, current EOF 2593).2017-03-29 00:24:32  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing /u02/ggs/dirdat/td000000.2017-03-29 00:24:32  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u02/ggs/dirdat/td000000 (byte 2593, current EOF 2593).2017-03-29 00:24:33  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing /u02/ggs/dirdat/td000000 to disk.2017-03-29 00:24:33  INFO    OGG-01735  Oracle GoldenGate Collector for Oracle:  Synchronizing /u02/ggs/dirdat/td000000 to disk.2017-03-29 00:24:33  INFO    OGG-01670  Oracle GoldenGate Collector for Oracle:  Closing /u02/ggs/dirdat/td000000.2017-03-29 00:24:33  INFO    OGG-01669  Oracle GoldenGate Collector for Oracle:  Opening /u02/ggs/dirdat/td000001 (byte -1, current EOF 0).

[oracle@demotarget ggs]$ ps -ef | grep mgrroot        22     2  0 00:00 ?        00:00:00 [async/mgr]postfix   2117  2106  0 00:01 ?        00:00:00 qmgr -l -t fifo -uoracle    2495     1  0 00:24 ?        00:00:00 ./mgr PARAMFILE /u02/ggs/dirprm/mgr.prm REPORTFILE /u02/ggs/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRSoracle    2508  2467  0 00:26 pts/1    00:00:00 grep mgr[oracle@demotarget ggs]$ ps -ef | grep 2495oracle    2495     1  0 00:24 ?        00:00:00 ./mgr PARAMFILE /u02/ggs/dirprm/mgr.prm REPORTFILE /u02/ggs/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRSoracle    2500  2495  0 00:24 ?        00:00:00 ./server -w 300 -p 7819-12818 -m 7809 -k -l /u02/ggs/ggserr.logoracle    2510  2467  0 00:26 pts/1    00:00:00 grep 2495[oracle@demotarget ggs]$ 如上可以看到:mgr的进程号是2495,server进程的父进程号是2495.也就是说,是mgr进程产生了server进程.

0 0