My Oracle Support Banner

GGSCI outputs incorrect status. (Doc ID 2127161.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle GoldenGate - Version 12.1.2.1.5 and later
Information in this document applies to any platform.

Goal

The "Info" command shows that the Manager, Extract and Replicat are STOPPED when in fact they are all running:

GGSCI > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED
EXTRACT STOPPED <extract_name>00:00:02 00:00:05
REPLICAT STOPPED <replicat_name> 00:00:00 00:00:09


GGSCI > info mgr

Manager is running (IP port 8809, Process ID 25289).


GGSCI > send <extract_name>status

Sending STATUS request to EXTRACT <extract_name>...


EXTRACT <extract_name>(PID 25302)
  Current status: Recovery complete: Processing data

  Current read position:
  Redo thread #: 6
  Sequence #: 44215
  RBA: 7580600
  Timestamp: 2016-04-11 11:29:48.000000
  SCN: 28.3622749831
  Current write position:
  Sequence #: 15
  RBA: 830659
  Timestamp: 2016-04-11 11:29:45.190955
  Extract Trail: <path>



GGSCI > send <replicat_name> status

Sending STATUS request to REPLICAT <replicat_name>...
  Current status: At EOF
  Sequence #: 15
  RBA: 839856
  0 records in current transaction
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.