GGSCI outputs incorrect status. (Doc ID 2127161.1)

Last updated on JANUARY 14, 2017

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 RE02I 00:00:02 00:00:05
REPLICAT STOPPED RR02I 00:00:00 00:00:09


GGSCI > info mgr

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


GGSCI > send re02i status

Sending STATUS request to EXTRACT RE02I ...


EXTRACT RE02I (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: ./dirdat/RI



GGSCI > send rr02i status

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

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms