OGG-00665 OCI Error describe for query (status = 1031-ORA-01031: insufficient privileges) (Doc ID 2137888.1)

Last updated on MAY 13, 2016

Applies to:

Oracle GoldenGate - Version 11.2.1.0.14 to 11.2.1.0.39 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Running Goldengate Classic extract 11.2.x after upgraded Oracle database from 11g to 12c will ABEND with error:



2016-05-13 07:33:24 ERROR OGG-00665 OCI Error describe for query (status = 1031-ORA-01031: insufficient privileges), SQL<SELECT o.obj# FROM sys.obj$ o, sys.user$ u, sys.tab$ t
WHERE o.name = UPPER('OBJ$') AND o.owner# = u.user# AND u.name = UPPER('SYS') AND o.obj# = t.obj#>.

 

Changes

 Upgraded Oracle RDBMS from 11g to 12c, but Goldengate is still 11.2

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