Erro ao gerar report statspack<\/p>\n
ORA-20200: Database\/Instance 2251672657\/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line 23<\/p>\n
11:47:51 PERFSTAT@ORCL > @?\/rdbms\/admin\/spreport\n\nCurrent Instance\n~~~~~~~~~~~~~~~~\n\n DB Id DB Name Inst Num Instance\n----------- ------------ -------- ------------\n 2251672657 ORCL 1 ORCL\n\nElapsed: 00:00:00.01\n\n\nInstances in this Statspack schema\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\nUsing 2251672657 for database Id\nUsing 1 for instance number\ndeclare\n*\nERROR at line 1:\nORA-20200: Database\/Instance 2251672657\/1 does not exist in\nSTATS$DATABASE_INSTANCE\nORA-06512: at line 23\n\n\nDisconnected from Oracle Database 11g Release 11.2.0.4.0 - 64bit Production\n<\/pre>\nCausa.<\/p>\n
Erro gerado ap\u00f3s o statspack instalado.<\/p>\n
Solu\u00e7\u00e3o.<\/p>\n
Aguardar gerar o Snap Autom\u00e1tico ou gerar manualmente.<\/p>\n
12:01:52 SYS@ORCL > @?\/rdbms\/admin\/spreport\n\nCurrent Instance\n~~~~~~~~~~~~~~~~\n\n DB Id DB Name Inst Num Instance\n----------- ------------ -------- ------------\n 2251672657 ORCL 1 ORCL \n\nElapsed: 00:00:00.01\n\n\nInstances in this Statspack schema\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n\n DB Id Inst Num DB Name Instance Host\n----------- -------- ------------ ------------ ------------\n 2251672657 1 ORCL ORCL bdora-01.\n local\n\nUsing 2251672657 for database Id\nUsing 1 for instance number\n\n\nSpecify the number of days of snapshots to choose from\n~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\nEntering the number of days (n) will result in the most recent\n(n) days of snapshots being listed. Pressing <return> without\nspecifying a number lists all completed snapshots.\n\n\n\nListing all Completed Snapshots\n\n Snap\nInstance DB Name Snap Id Snap Started Level Comment\n------------ ------------ --------- ----------------- ----- --------------------\nORCL ORCL 1 31 Dec 2018 12:00 5\n<\/pre>\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Erro ao gerar report statspack ORA-20200: Database\/Instance 2251672657\/1 does not exist in STATS$DATABASE_INSTANCE ORA-06512: at line 23 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…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-685","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=685"}],"version-history":[{"count":0,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:attachment":[{"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rodrigosilvaesilva.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}