PLS-00201 for 'CTX_REPORT in EMAGENT.TRC file (Doc ID 1052647.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 15-Mar-2013


Symptoms

EMAGENT.TRC is showing following error many times.


ORA-06550: line 223, column 8:
PLS-00201: identifier 'CTX_REPORT.DESCRIBE_INDEX' must be declared
ORA-06550: line 223, column 8:
PL/SQL: Statement ignored
ORA-06550: line 302, column 6:
PLS-00201: identifier 'CTX_REPORT.INDEX_SIZE' must be declared
ORA-06550: line 302, column 6:
PL/SQL: Statement ignored
2009-12-20 14:15:54,133 Thread-719 ERROR engine: [oracle_database,DWH01.mobilcom.de,textIndexStats] : nmeegd_GetMetricData failed : ORA-06550: line 48, column 5:
PLS-00201: identifier 'CTX_REPORT.INDEX_STATS' must be declared
ORA-06550: line 48, column 5:
PL/SQL: Statement ignored
ORA-06550: line 223, column 8:
PLS-00201: identifier 'CTX_REPORT.DESCRIBE_INDEX' must be declared
ORA-06550: line 223, column 8:
PL/SQL: Statement ignored
ORA-06550: line 302, column 6:


PLS-00201: identifier 'CTX_REPORT.INDEX_SIZE' must be declared
ORA-06550: line 302, column 6:
PL/SQL: Statement ignored

Changes

While using OEM or DBconsole or Grid control with a  database which does not have Oracle Text installed.

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