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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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.

advertisements
 
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

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (578) General (60) Unix (47) Script (41) Blog (23) OCI (3) SQL* Loader (3) Datapump (2) Software (1)
DBA Tips
 

acehints.com Copyright 2011-21 All Rights Reserved | Site Map | Contact | Disclaimer