My Oracle Support Banner

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 FEBRUARY 06, 2020

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  3> dblogin userid <gg_adm> password <passwd>
Successfully logged into database.

GGSCI  4> MININGDBLOGIN userid <gg_adm> password <passwd>
Successfully logged into mining database.

GGSCI  5> STOP EXTRACT <extract_name>
EXTRACT IWNDMXME is already stopped.

GGSCI 6> UNREGISTER EXTRACT <extract_name> DATABASE

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

GGSCI 7> REGISTER EXTRACT <extract_name> DATABASE

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

Cause

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
Symptoms
Cause
Solution


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