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

Cause:

This error occur because there is 0 snapshot stored in stats$snapshot table

kIsH@Xhydra<>@?/rdbms/admin/spreport

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1010810948 DB9ZX               1 db9zx



Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Using 1010810948 for database Id
Using          1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 1010810948/1 does not exist in
STATS$DATABASE_INSTANCE
ORA-06512: at line 23

Check if there are rows under the table stats$snapshot

kIsH@Xhydra<>select count(*) from stats$snapshot;

  COUNT(*)
----------
         0

Manually execute the snapshot

kIsH@Xhydra<>exec STATSPACK.SNAP;

PL/SQL procedure successfully completed.

Report proceeded to begin snap prompt

kIsH@Xhydra<>@?/rdbms/admin/spreport

Current Instance
~~~~~~~~~~~~~~~~

   DB Id    DB Name      Inst Num Instance
----------- ------------ -------- ------------
 1010810948 DB9ZX               1 db9zx



Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   DB Id    Inst Num DB Name      Instance     Host
----------- -------- ------------ ------------ ------------
 1010810948        1 DB9ZX        db9zx        xhydra

Using 1010810948 for database Id
Using          1 for instance number


Specify the number of days of snapshots to choose from
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Entering the number of days (n) will result in the most recent
(n) days of snapshots being listed.  Pressing <return> without
specifying a number lists all completed snapshots.



Listing all Completed Snapshots


Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1

Leave a Reply