My Oracle Support Banner

GGSCI outputs incorrect status. (Doc ID 2127161.1)

Last updated on DECEMBER 23, 2019

Applies to:

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


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

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


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

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