Extract/Replicat Shows Already Running When Started and Already Stopped When Stopped from GGSCI, OGG-01031, Reply received is Unable to open file (Doc ID 1318980.1)

Last updated on JULY 21, 2017

Applies to:

Oracle GoldenGate - Version 5.0.0 and later
Information in this document applies to any platform.
INTERNAL Checked for currency on 11-Dec-2012

Symptoms

The Oracle GoldenGate (OGG) extract (or replicat) shows status abended.
Trying to start it, it says already running.
Trying to stop it, it says already stopped.

GGSCI  24> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EP1EFMD7 00:00:00 00:00:00
EXTRACT ABENDED PP1EFMD7 00:00:00 02:28:40

GGSCI  25> stop PP1EFMD7
EXTRACT PP1EFMD7 is already stopped.

GGSCI  26> start PP1EFMD7
EXTRACT PP1EFMD7 is already running.

GGSCI  27> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EP1EFMD7 00:00:00 00:00:03
EXTRACT ABENDED PP1EFMD7 00:00:00 02:30:35

Changes

This usually follows some kind of error recovery procedure.

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