ORA-20200: Database/Instance does not exist in DBA_HIST_DATABASE_INSTANCE

ORA-20200: Database/Instance does not exist in DBA_HIST_DATABASE_INSTANCE

Error
On Executing the AWR : awrrpt.sql from database then you got the following error:

Specify the location of AWR Data
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Using 2626913219 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 2626913219/1 does not exist in DBA_HIST_DATABASE_INSTANCE
ORA-06512: at line 27

Cause
NUMFORMAT in SQLPLUS session is in other format causing the problem.

Solution
1. Check the NUMFORMAT value.

Show numformat
numformat "999,999,999"

2. You need to set the numformat empty as default value:

--Set
SQL> set numformat ""
--Verify
SQL> Show numformat
numformat ""

3. Check the AWR report again.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply