Oracle 12C RAC報錯ORA-20001: Statistics Advisor

dbasdk發表於2017-11-30
Oracle
最近某濤oracle 12C RAC 資料庫是問題不斷，剛剛解決了 ora-07445問題，有的處理新問題，主要報錯如下：
alert日誌報錯資訊：
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_88"
ORA-20001: Statistics Advisor: Invalid Task Name For the current user <== Note it
ORA-06512: at "SYS.DBMS_STATS", line 46861
ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 734
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 19930
ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 21934
ORA-06512: at "SYS.DBMS_STATS", line 46851

官方給我的問題原因：
      

Seed database was most likely not created right by package dbms_stats.init_package not being ran. 

Dbms_stats.init_package creates statistics advisor. This procedure is executed during database creation. If something went wrong during database creation,(for example, init_package is not called for some reason), this kind of errors may be seen in alert log when auto job tries to execute. 


解決方法：

Run dbms_stats.init_package()  in the container database to create the tasks correctly: 

$ sqlplus / as sysdba

 EXEC dbms_stats.init_package();


column name format A35
set linesize 120

select name, ctime, how_created
  from sys.wri$_adv_tasks
 where owner_name = 'SYS'
   and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');


Output of the query will look like this:

NAME                                 CTIME      HOW_CREATED
----------------------------------- ---------- ------------------------------
AUTO_STATS_ADVISOR_TASK              14-APR-16 CMD
INDIVIDUAL_STATS_ADVISOR_TASK        14-APR-16 CMD


文件ID : Doc ID 2127675.1

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29734436/viewspace-2148076/，如需轉載，請註明出處，否則將追究法律責任。

相關文章