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 18.104.22.168.4 and later
Information in this document applies to any platform.
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 22.214.171.124.15, compatible set to 126.96.36.199, with patch 21373865 for OGG installed.
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