OEM 12c - AWR Report - User Cannot Run In 12c After Being Able To Run In OEM 10g
(Doc ID 1536954.1)
Last updated on JUNE 10, 2021
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
User with DBA credentials in DB cannot run AWR report in OEM 12c after being able to run AWR reports in OEM 10g.
Error being received in OEM 12c is:
You must have EXECUTE privilege on DBMS_WORKLOAD_REPOSITORY to complete the task
User has DB role assigned in DB that he wants to run AWR reports against and DBA role has execute priv on sys.DBMS_WORKLOAD_REPOSITORY.
AWR report can be created manually.
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