Skip to content

How to Resolve ORA-20200: Database Instance does not exist

  • by

ORA-20200

When we ran a STATSPACK report, we got error ORA-20200.

SQL> @?/rdbms/admin/spreport.sql
...
ORA-20200: Database/Instance 356760607/1 does not exist in
STATS$DATABASE_INSTANCE
ORA-06512: at line 23

This is because you have not enabled the snapshot of STATSPACK. To solve ORA-20200, you should run spauto.sql before running the report.

SQL> conn perfstat/perfstat
Connected.
SQL> @?/rdbms/admin/spauto.sql
...

There's a complete procedure about how to install and run STATSPACK, you may take a look.

Leave a Reply

Your email address will not be published.