SYMPTOMS
A unidirectional replication from the source site to the target site.
The pump process is bending with the following errors in the report file, but communication between the source site and target site is working as expected.
2012-10-02 13:01:06 WARNING OGG-01223 TCP/IP error 146 (Connection refused). 2012-10-02 13:01:47 WARNING OGG-01223 TCP/IP error 146 (Connection refused). 2012-10-02 13:02:28 WARNING OGG-01223 TCP/IP error 146 (Connection refused). 2012-10-02 13:02:53 WARNING OGG-01223 Unknown error sending data over TCP. Please check if intended receiver program is running (for example server or manager). 2012-10-02 13:03:23 WARNING OGG-01223 TCP/IP error 146 (Connection refused). 2012-10-02 13:04:04 WARNING OGG-01223 TCP/IP error 146 (Connection refused). Source Context : SourceModule : [er.extrout] SourceID : [/scratch/angorant/view_storage/angorant_fbo2_Sparc9_120423.0230/oggcore/OpenSys/src/app/er/extrout.c] SourceFunction : [tcp_send_data] SourceLine : [1352] 2012-10-02 13:04:45 ERROR OGG-01224 TCP/IP error 146 (Connection refused); retries exceeded. 2012-10-02 13:04:45 ERROR OGG-01668 PROCESS ABENDING.
Target site manager process is up and running and listening on specified port
CAUSE
Target site manager is not being able to start server collector process in a port as per connection refused error
On target site ggserr.log file we can see:
2012-10-08 13:25:13 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from EXTRACT on host qahq1 (START SERVER CPU -1 PRI -1 TIMEOUT 300 PARAMS ).
2012-10-08 13:25:13 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
2012-10-08 13:25:13 WARNING OGG-01834 Oracle GoldenGate Collector for Oracle: Failed setting IPv6 socket to dual stack mode (error: 99, Option not supported by protocol).
2012-10-08 13:25:13 ERROR OGG-01224 Oracle GoldenGate Collector for Oracle: opening port to MGR from SERVER failed with 1:Connection refused.
2012-10-08 13:25:13 ERROR OGG-01668 Oracle GoldenGate Collector for Oracle: PROCESS ABENDING.
SOLUTION
Target site /etc/hosts file contain an invalid ID for localhost:
::1 qadr localhost —> Wrong ID 127.0.0.1 name1 localhost loghost 192.168.1.1 na192.168.1.2 name2 192.168.1.3 name3
Invalid ID line should be removed from /etc/hosts and manager at target site should be restarted. 127.0.0.1 name1 localhost loghost 192.168.1.1 name1 192.168.1.2 name2 192.168.1.3 name3