My Oracle Support Banner

OGG-01755 Cannot register or unregister EXTRACT because of the following SQL error: OCI Error 20001 (Doc ID 2245120.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

Receiving error OGG-1755 with OCI Error 20001 when attempting to register an Integrated Extract.

GGSCI (test01) 4> register EXTRACT E_TKP_DR DATABASE

2017-03-16 10:59:44 ERROR OGG-01755 Cannot register or unregister EXTRACT E_TKP_DR because of the following SQL error: OCI Error 20001. See Extract user privileges in the Oracle GoldenGate for Oracle Installation and Setup Guide.

 

 The OGG user has all privileges listed in Oracle docs. Database is version 11.2.0.3.15, compatible set to 11.2.0.3, with patch 21373865 for OGG installed.

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
References


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