Skip to content

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


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
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
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. Required fields are marked *