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 JULY 17, 2018

Applies to:

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


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


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

at oracle.jdbc.driver.T4CTTIoer.processError(

at oracle.jdbc.driver.T4CTTIoer.processError(

at oracle.jdbc.driver.T4C8Oall.processError(

at oracle.jdbc.driver.T4CTTIfun.receive(

at oracle.jdbc.driver.T4CTTIfun.doRPC(

at oracle.jdbc.driver.T4C8Oall.doOALL(


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


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