OGG Register Integrated Extract Failed with OGG-01755 SQL Error: OCI Error 1,653 (Doc ID 1511362.1)

Last updated on JANUARY 18, 2017

Applies to:

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

Symptoms

Unable to register extract for Integrated Extract

ggsci 3> register extract ext1 database
  2012-12-05 11:51:02 WARNING OGG-02064 Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.
  2012-12-05 11:51:16 ERROR OGG-01755 Cannot register or unregister EXTRACT EXT1 because of the following SQL error: OCI Error 1,653. See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

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