Extract Abended With Error "ORA-00942: table or view does not exist, SQL< select value$ from sys.props$ where name = 'NLS_LANGUAGE'>"

(Doc ID 1274300.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.7 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

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