OGG-01755 Cannot Register Or Unregister EXTRACT EPL_SOL1 Because Of The Following SQL Error: OCI Er (Doc ID 1628982.1)

Last updated on JULY 17, 2017

Applies to:

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

Symptoms

Integrated EXTRACT registration fails:

GGSCI (atlhx005) 1> DBLOGIN USERID GGADMIN@DRPCU02 PassWord fordbas
Successfully logged into database.

GGSCI (atlhx005) 2> MININGDBLOGIN USERID GGADMIN@SLDOWNST PassWord ggadmin
Successfully logged into mining database.

GGSCI (atlhx005) 3> REGISTER EXTRACT EPL_SOL1 DATABASE

2014-02-24 10:11:42  WARNING OGG-02064  Oracle compatibility version 11.2.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.

2014-02-24 10:11:42  ERROR   OGG-01755  Cannot register or unregister EXTRACT EPL_SOL1 because of the following SQL error: OCI Error 6550. 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