Register Extract In Goldengate Fails with OCI Error 959 (Doc ID 2277427.1)

Last updated on JUNE 15, 2017

Applies to:

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

Symptoms

 

Cannot register extract in Goldengate . It abends with the  OCI Error 959.

 

GGSCI (hyperdbt as ggowner@hyperdbt) 2> register extract eamtabdi, database

2017-05-30 16:34:13 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.

2017-05-30 16:34:46 ERROR OGG-08221 Cannot register or unregister EXTRACT EAMTABDI because of the following SQL error: OCI Error 959.

 

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