OGG-01223 TCP/IP error 111

今天检查ogg发现有投递进程abend，手动start检查ggserr.log

$ tail -f /ogg/ogggw/ggserr.log 
2017-04-14 15:40:05  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extaa.prm:  Rolling over remote file ./dirdat/aa000003.
2017-04-14 15:40:05  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extaa.prm:  Recovery completed for target file ./dirdat/aa000004, at RBA 1085.
2017-04-14 15:40:05  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extaa.prm:  Recovery completed for all targets.
2017-04-14 15:40:10  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extbb.prm:  Rolling over remote file ./dirdat/bb000011.
2017-04-14 15:40:10  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extbb.prm:  Recovery completed for target file ./dirdat/bb000012, at RBA 1085.
2017-04-14 15:40:10  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extbb.prm:  Recovery completed for all targets.
2017-04-14 15:40:10  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dpecc.prm:  TCP/IP error 111 (Connection refused), endpoint: 100.14.132.64:7819.
2017-04-14 15:40:18  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, extdd.prm:  Rolling over remote file ./dirdat/repsd/dd000062.
2017-04-14 15:40:18  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, extdd.prm:  Recovery completed for target file ./dirdat/repsd/dd000063, at RBA 1091.
2017-04-14 15:40:18  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, extdd.prm:  Recovery completed for all targets.
2017-04-14 15:40:50  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dpecc.prm:  TCP/IP error 111 (Connection refused), endpoint: 100.14.132.64:7819.
2017-04-14 15:41:01  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): stop dpecc.
2017-04-14 15:41:30  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dpecc.prm:  TCP/IP error 111 (Connection refused), endpoint: 100.14.132.64:7819.
2017-04-14 15:41:31  INFO    OGG-01021  Oracle GoldenGate Capture for Oracle, dpecc.prm:  Command received from GGSCI: STOP.
2017-04-14 15:41:54  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): send dpecc forcestop.

搜索mos上发现有文章符合该输出

CAUSE

No ports available for the target manager to start a dynamic server collector.

When issued the following command in the target ggsci

ggsci> send manager childstatus debug

We might see that all the ports mentioned in the target manager dynamicportlist is already been used.

SOLUTION

Ensure that you have more ports open and then use that bigger range in the target manager parameter file under dynamicportlist.

Now stop/ start the target manager and then restart the source pump extract.

其实，文章中提到是目标端的mgr参数文件的动态参数列表中的端口号已经都被使用了。所以很简单

1.目标端停止所有进程

2.修改mgr参数，扩充动态参数列表中的端口号的范围

3.开启mgr进程。

4.目标端开启复制进程，开启其他进程，源端开启投递进程。