OGG 投递进程报错,TCP/IP error 111 (Connection refused)

最近遇到一个OGG投递进程Abend,处理后,在测试环境进行测试。

1.目标端关闭MGR进程后

2.远端投递进程重启

GGSCI (t1) 38> start dpea
Sending START request to MANAGER ...
ERROR: Cannot create process '/u01/ogg/base/extract'. Child process is no longer alive
2020-07-28 09:04:19  WARNING OGG-01742  Command sent to MGR MGR returned with an ERROR response.

观察
[ogg@t1 base]$ tail -200f ggserr.log 

2020-07-28T09:04:19.591-0700 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, dpea.prm: EXTRACT DPEA started.
2020-07-28T09:04:19.591-0700 ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, dpea.prm: TCP/IP error 111 (Connection refused), endpoint: 10.0.0.32:7809.
2020-07-28T09:04:19.591-0700 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, dpea.prm: PROCESS ABENDING.
2020-07-28T09:04:19.571-0700 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: Cannot create process '/u01/ogg/base/extract'. Child process is no longer alive.
2020-07-28T09:04:19.571-0700 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: startER failed.

3.观察网络是否可用?

$ telnet 10.0.0.32 7809
端口不通!
之前是好的,为啥端口不通呢???

4.小结

登录OGG 目标端主机
服务端口是否已开启 
# ss -ntl|grep 7809
Null
根据端口被哪些进程占用
# lsof -i:7809

 netstat -anp 也可以显示系统端口使用情况

# netstat -antp|grep 7809
Null

GGSCI (t2) 8> info mgr

Manager is DOWN!

启动目标端MGR

GGSCI (t2) 9> start mgr
Manager started

[root@t2 ~]# ss -ntl|grep 7809
LISTEN 0 50 :::7809 :::*

[root@t2 ~]# lsof -i:7809
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
mgr 19903 ogg 7u IPv6 76653 0t0 TCP *:7809 (LISTEN)

[root@t2 ~]# netstat -antp|grep 7809
tcp6 0 0 :::7809 :::* LISTEN 19903/./mgr

源端,再次启动投递进程

GGSCI (t1) 41> start dpea

 

[root@t2 ~]# netstat -antp|grep 7809
tcp6 0 0 :::7809 :::* LISTEN 19903/./mgr
tcp6 0 0 10.0.0.32:7809 10.0.0.31:29828 TIME_WAIT -
tcp6 0 0 ::1:7809 ::1:60949 TIME_WAIT -
tcp6 0 0 10.0.0.32:7809 10.0.0.31:29830 TIME_WAIT -

对于Oracle来说,如果目标端MGR没启动!!!那么源端投递进程将无法正常投递传输文件,因为目标端相关的端口并未打开,目标端无法接收文件。

其次:生产环境遇到另一个问题:
1.源端投递10.1 IP地址;
2.目标端OGG软件使用Oracle ACFS文件系统,/OGG目录共享,此时,不知道谁在节点2启动了MGR进程,导致源端投递进程报错,无法正常投递,
因为对于目标端OGG来说,开放的MGR端口是10.2 节点2的IP及对应MGR;
3.解决方法很简单【1.关闭节点2Mgr,节点1启动mgr,源端OGG投递进程启动;2.远端投递进程修改host ip指向node2 ,在启动投递进程即可】
原文地址:https://www.cnblogs.com/lvcha001/p/13391880.html