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 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
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
| Symptoms |
| Cause |
| Solution |
| References |