OGG-00665

Applies to:

Oracle GoldenGate - Version: 11.1.1.0.7 and later   [Release: 11.1.1 and later ]
Information in this document applies to any platform.

Symptoms

When attempting to start an Extract, we get error

2010-12-09 18:59:25 GGS ERROR 182 OCI Error describe for query (bad syntax) (status = 942-ORA-00942: table or view does not exist), SQL< select value$ from sys.props$ where name = 'NLS_LANGUAGE'>.

2010-12-09 18:59:25 GGS ERROR 190 PROCESS ABENDING.


Cause

The database user does not have the necessary privilege.

Solution

Grant the necessary privilege to the Golden Gate user.

SQL> grant select on sys.props$ to ggsuser;
or
SQL> grant select any dictionary to ggsuser;