I encountered TCP/IP error 111 (connection refused) in my source DB. I ran view ggsevt.
Source
2013-09-06 17:47:41 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI c
ommand (oracle): edit params mgr.
2013-09-06 17:48:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI c
ommand (oracle): stop extract ext1.
2013-09-06 17:48:05 WARNING OGG-01223 Oracle GoldenGate Capture for Oracle, ext1.prm: TCP/IP er
ror 111 (Connection refused).
Target
2013-09-06 17:49:38 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting fo
r connection (started dynamically).
2013-09-06 17:49:54 ERROR OGG-01224 Oracle GoldenGate Collector for Oracle: opening po
rt to MGR from SERVER failed with 2:Could not establish host TCP/IP address.
2013-09-06 17:49:54 ERROR OGG-01668 Oracle GoldenGate Collector for Oracle: PROCESS AB
ENDING.
Firewall is cleared, I can telnet from source to target with port 7809. Not an issue. Checked in another post where a user encountered error in /etc/hosts. My settings are perfect right.
[oracle@db1 dirdat]$ telnet db4 7809
Trying 192.168.56.101...
Connected to db4.localdomain (192.168.56.101).
Escape character is '^]'.
Connection closed by foreign host.
Source:
> edit params mgr
DYNAMICPORTLIST 7000-9000
PORT 7809
Any help is much appreciated.