Erro ao gerar report statspack
ORA-20200: Database/Instance 2251672657/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line 23
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
11:47:51 PERFSTAT@ORCL > @?/rdbms/admin/spreport Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 2251672657 ORCL 1 ORCL Elapsed: 00:00:00.01 Instances in this Statspack schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Using 2251672657 for database Id Using 1 for instance number declare * ERROR at line 1: ORA-20200: Database/Instance 2251672657/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line 23 Disconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production |
Causa.
Erro gerado após o statspack instalado.
Solução.
Aguardar gerar o Snap Automático ou gerar manualmente.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 |
12:01:52 SYS@ORCL > @?/rdbms/admin/spreport Current Instance ~~~~~~~~~~~~~~~~ DB Id DB Name Inst Num Instance ----------- ------------ -------- ------------ 2251672657 ORCL 1 ORCL Elapsed: 00:00:00.01 Instances in this Statspack schema ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ DB Id Inst Num DB Name Instance Host ----------- -------- ------------ ------------ ------------ 2251672657 1 ORCL ORCL bdora-01. local Using 2251672657 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 Snap Instance DB Name Snap Id Snap Started Level Comment ------------ ------------ --------- ----------------- ----- -------------------- ORCL ORCL 1 31 Dec 2018 12:00 5 |