揭示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进程.