一個新安裝的12.2RAC環境，后臺有日志報錯如下：

2021-12-25T10:35:00.405492-05:00 Errors in file /oracle/app/oracle/diag/rdbms/bdcqx/bdcqx1/trace/bdcqx1_j000_16387.trc: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_118" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47207 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line 47197

這是12C的問題，參照MOS文檔進行處理即可：
ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2.0 Database version or higher release (like 18c) (Doc ID 2127675.1)
升級到12.2.0.1后數據庫自動任務失敗報錯ORA-20001和ORA-00932 (Doc ID 2504954.1)

處理前查詢：

處理前查詢： QL> column name format A35 SQL> set linesize 120 SQL> SQL> select name, ctime, how_created2 from sys.wri$_adv_tasks3 where owner_name = 'SYS'4 and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');no rows selectedSQL> EXEC dbms_stats.init_package();PL/SQL procedure successfully completed.處理后查詢： SQL> column name format A35 SQL> set linesize 120 SQL> SQL> select name, ctime, how_created2 from sys.wri$_adv_tasks3 where owner_name = 'SYS'4 and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');NAME CTIME HOW_CREATED ----------------------------------- --------- ------------------------------ AUTO_STATS_ADVISOR_TASK 25-DEC-21 CMD INDIVIDUAL_STATS_ADVISOR_TASK 25-DEC-21 CMD

總結

以上是生活随笔為你收集整理的12.2版本数据库ORA-20001: Statistics Advisor: Invalid task name for the current user的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。