Fail to run AWR report
656983Sep 18 2009 — edited Sep 18 2009Dear support,
I fail to generate AWR report on Oracle RAC environmnet with the following error. Kindly advise on this issue
SQL> connect /as sysdba
Connected.
SQL> @awrrpt.sql
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
975288211 CMSHA 1 CMSHA1
Specify the Report Type
~~~~~~~~~~~~~~~~~~~~~~~
Would you like an HTML report, or a plain text report?
Enter 'html' for an HTML report, or 'text' for plain text
Defaults to 'html'
Enter value for report_type: html
Type Specified: html
Instances in this Workload Repository schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Using 975288211 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 975288211/1 does not exist in
DBA_HIST_DATABASE_INSTANCE
ORA-06512: at line 23