Golden Gate May mislead you if you haven’t started Manager. When i tried to start the Pump process, the process was abended with the error OGG-01224 TCP/IP error 111 (Connection refused).
Everything was working well, and suddenly this error appeared as there was a change in firewall policies or rules. I thought the same but realized it was my silly mistake.
2022-06-27 12:37:46 ERROR OGG-01224 TCP/IP error 111 (Connection refused), endpoint: ORA-X2:7809; retries exceeded. 2022-06-27 12:37:46 ERROR OGG-01668 PROCESS ABENDING. GGSCI (ORA-X1 as ggadmin@PRODS) 34>
for further troubleshooting, use telnet to verify whether the manager port is opened or not.
GGSCI (ORA-X1 as ggadmin@PRODS) 36> sh telnet ORA-X2 7809 Trying 192.168.1.120... telnet: connect to address 192.168.1.120: Connection refused GGSCI (ORA-X1 as ggadmin@PRODS) 37>
The above output clearly states that the port was not open. After some troubleshooting, i tried to verify each of the processes and then identified the target manager process was not running.
I’ve started the MGR process and pump, i was able to start on the source without any issues.
GGSCI> start mgr
If the target manager is not running, the port will not be in LISTEN mode. Hence if the source Pump tries to communicate, the port will not be in reachable mode. In this case, the issue is a purely manual error.
