GoldenGate NSK Extract Hangs in Starting State And is Not Moving

(Doc ID 1381055.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle GoldenGate - Version: 9.5.1.8 and later   [Release: 9.5.1 and later ]
Information in this document applies to any platform.

Symptoms

  • Oracle GoldenGate (OGG) Extract hangs in starting state and never comes to running status

    GGSCI> info <extract>,detail
    Extract MYEXTRACT Initialized 2011-11-11 11:11 Status STARTING
    Process $GGE16 Checkpoint Lag: 9999K, 172:53:52 (updated 146:07:21 ago)
    Log Read Checkpoint \SBM01.$DATA2.GLOGGGL.AA012712
    2011-11-11 10:01:14, RBA 40199273
    ...

  • Altering the extract to the next seq doesn't change the behaviour.
  • Also send <process name>, status command is giving error 40.
  • Extract parameter file has dictionary parameter included.

Cause

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