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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.