My Oracle Support Banner

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 NOVEMBER 27, 2019

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.