My Oracle Support Banner

OEM 12c - AWR Report - User Cannot Run In 12c After Being Able To Run In OEM 10g (Doc ID 1536954.1)

Last updated on FEBRUARY 08, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 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

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