OGG-01755/OGG-08241 trying to register integrated extract after it has been un-registered (Doc ID 2294690.1)

Last updated on AUGUST 07, 2017

Applies to:

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

Symptoms

Trying to register an integrated extract process that was previously unregistered fails with the following error:

GGSCI (alth077) 4> REGISTER EXTRACT MYIEXT1 DATABASE

2017-08-07 13:17:39 WARNING OGG-01758 This EXTRACT MYIEXT1 is already registered with the database.

an un-register extract fails with the errors:

2017-08-03 14:41:34 ERROR OGG-01755 Cannot register or unregister EXTRACT MYIEXT1 because of the following SQL error: OCI Error retrieving bind info for query (status = 100). See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

In GoldenGate 12c the register fails with an error:

 

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