Last updated on NOVEMBER 04, 2015
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms