ORA-20200: Database/Instance does not exist in STATS$DATABASE_INSTANCE

by Eric Jenkinson on August 13, 2010

Categories: Errors,Performance

Tagged: , ,

When attempting to run a Statspack instance report using spreport.sql the following error is generated.

SQL> @spreport.sql

Current Instance

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1253224498 ORCL                1 orcl

Instances in this Statspack schema

Using 1253224498 for database Id
Using          1 for instance number
ERROR at line 1:
ORA-20200: Database/Instance 1253224498/1 does not exist in
ORA-06512: at line 23

Disconnected from Oracle Database 11g Enterprise Edition Release - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


Upon receiving the error you verify the DBID using V$DATABASE with the value in STATS$DATABASE_INSTANCE.

SQL> select dbid from v$database;


SQL> select * from stats$database_instance;

no rows selected


You see that no rows are in STATS$DATABASE_INSTANCE.

This error can occur if spreport.sql is ran before any snapshots have been taken. Try creating a snapshot using execute statspack.snap and rerun spreport.sql.

If you have an automated process to collect snapshots ensure that it is running properly and executing the correct procedure.


Post A Comment