OGG-08221 Cannot Register or Unregister EXTRACT<EXTRACT_NAME> because of the following SQL error: OCI Error 25,153 (Doc ID 2225566.1)

Last updated on JANUARY 20, 2017

Applies to:

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

Symptoms

When registering new Integrated Extract it fails with below


GGSCI (iwdc1preoradb05) 2> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT STOPPED IWNDMXME 00:00:00 21:42:02
EXTRACT STOPPED IWNDMXMP 00:00:00 21:40:21

GGSCI (iwdc1preoradb05) 3> dblogin userid ogg_adm@MAXPRJ2 password welcome123
Successfully logged into database.

GGSCI (iwdc1preoradb05 as ogg_adm@MAXPRJ22) 4> MININGDBLOGIN userid ogg_adm@MAXPRJ2 password welcome123
Successfully logged into mining database.

GGSCI (iwdc1preoradb05 as ogg_adm@MAXPRJ22) 5> STOP EXTRACT IWNDMXME
EXTRACT IWNDMXME is already stopped.

GGSCI (iwdc1preoradb05 as ogg_adm@MAXPRJ22) 6> UNREGISTER EXTRACT IWNDMXME DATABASE

2017-01-13 16:48:39 ERROR OGG-08222 EXTRACT IWNDMXME must be registered with the database to perform this operation.

GGSCI (iwdc1preoradb05 as ogg_adm@MAXPRJ22) 7> REGISTER EXTRACT IWNDMXME DATABASE

2017-01-13 16:49:15 ERROR OGG-08221 Cannot register or unregister EXTRACT IWNDMXME because of the following SQL error: OCI Error 25,153.

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