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