Manually Run AWR Report Hangs On OEM 12c (Doc ID 1924525.1)

Last updated on OCTOBER 09, 2014

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.3.0 and later
Information in this document applies to any platform.

Symptoms

when running an Automatic Workload Repository report from the Performance Tab in OEM 12.1 the report hangs

The report will run manually (ie if run from SQLPLUS or Toad)

The user who is running OEM (ie the credentials) does not seem to matter .. (ie sysdba or other privileged usera)

The following query returns more than one row

select DISTINCT instance_number from DBA_HIST_DATABASE_INSTANCE where instance_name IN ( '<instance_name>')

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms