Required privileges are missing. Please ensure you have SELECT privilege to CTXSYS objects with EM 12c And Text Manager (Doc ID 1951798.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

When logging into db console/cloud control as any user (sysdba/non-sysdba) and attempting to view Text Indexes in OEM: Targets -> Databases -> choose DB -> Schema -> Text Manager -> Text indexes

The user may see the following error message:

 

Also the EM log (emoms.log) contains errors like below

[EMUI_14_16_59_/console/database/txt/textIndexes]

ERROR adm.misc logException.3953 - java.sql.SQLException: ORA-01410: invalid ROWID

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

 

Oracle Text Healthcheck also has errors noted in "Ten (10) most recent text index errors (ctx_index_errors)" Section

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