ORA-942 Error Appears When Clicking AWR Report Link In 18c EM Express
(Doc ID 2502919.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
When clicking the AWR Report link from 18c Enterprise Manager Express, ORA-942 error dialogue appears:
ORA-00942: table or view does not exist
The error is raised only when the connected user is not SYS.
The user is granted EM_EXPRESS_ALL and EM_EXPRESS_BASIC roles.
This error may start to appear under following changes:
- Previously the link worked fine when connected as SYS user but connecting as other users raise ORA-942
- EM Express worked fine before the database was upgraded to 18c.
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