GoldenGate Start Extract Pump Failing / Abending with OGG-01224 TCP/IP error 111 (Connection refused)

Problem Description
GoldenGate start extract pump command getting abend and ggserr.log log shows the following error message.
2016-09-22 12:31:39  ERROR   OGG-01224  Oracle GoldenGate Capture for Oracle, pmp_dest.prm:  TCP/IP error 111 (Connection refused), endpoint: Node 1:7810.


Solution Description
In this particular scenario, when I see the port number(7810) and server(Node 1) I could managed to identify the port is pointing to my replication manager port in the target system site. The manger on the replication / target site was down. When I started the Manager the issue is resolved in the primary site.

1.      Check the status of the Pump extract and it is abended.
GGSCI (Node 1) 2> info PMP_DEST

EXTRACT    PMP_DEST  Last Started 2016-09-22 12:31   Status ABENDED
Checkpoint Lag       00:00:00 (updated 971:14:30 ago)
Log Read Checkpoint  File ./dirdat/ge000000000
                     First Record  RBA 1428

2.      Check the port and remote host details
GGSCI (Node 1) 3> view param PMP_DEST

EXTRACT PMP_DEST
USERID ggs_owner@onlinedb, PASSWORD ggs_owner
RMTHOST Node 1 , MGRPORT 7810
RMTTRAIL ./dirdat/ge
TABLE gpp_test.OGG_DDL_TST;

3.      Checking the manager status in the remote site.
GGSCI (Node 1) 2> info manager

Manager is DOWN!

4.      Start the manager using ggsci interface.
GGSCI (Node 1) 3> start manager
Manager started.

5.      Start the pump extract.
GGSCI (Node 1) 4> start PMP_DEST

Sending START request to MANAGER ...
EXTRACT PMP_DEST starting


GGSCI (Node 1) 5> info PMP_DEST

EXTRACT    PMP_DEST  Last Started 2016-09-22 12:44   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:06 ago)
Process ID           17219
Log Read Checkpoint  File ./dirdat/ge000000001

                     2016-09-22 12:03:43.981954  RBA 1491
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google