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

揭示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 mgr
root        22     2  0 00:00 ?        00:00:00 [async/mgr]
postfix   2117  2106  0 00:01 ?        00:00:00 qmgr -l -t fifo -u
oracle    2495     1  0 00:24 ?        00:00:00 ./mgr PARAMFILE /u02/ggs/dirprm/mgr.prm REPORTFILE /u02/ggs/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS
oracle    2508  2467  0 00:26 pts/1    00:00:00 grep mgr
[oracle@demotarget ggs]$ ps -ef | grep 2495
oracle    2495     1  0 00:24 ?        00:00:00 ./mgr PARAMFILE /u02/ggs/dirprm/mgr.prm REPORTFILE /u02/ggs/dirrpt/MGR.rpt PROCESSID MGR USESUBDIRS
oracle    2500  2495  0 00:24 ?        00:00:00 ./server -w 300 -p 7819-12818 -m 7809 -k -l /u02/ggs/ggserr.log
oracle    2510  2467  0 00:26 pts/1    00:00:00 grep 2495
[oracle@demotarget ggs]$ 

如上可以看到:mgr的进程号是2495,server进程的父进程号是2495.也就是说,是mgr进程产生了server进程.