设为首页 加入收藏

TOP

Orace 12.2 ORA-12012: error on auto execute of job “SYS"."ORA$AT_OS_OPT_SY_21”
2019-01-25 12:09:04 】 浏览:54
Tags:Orace 12.2 ORA-12012: error auto execute job SYS ORA AT_OS_OPT_SY_21

Errors in file /d12/app/oracle/diag/rdbms/test/test/trace/test_j001_4981.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_21"
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


看了一下报错频率,大概是每隔10分钟报一次。该库是12.2.0.1的CDB,其中还有两个pdb。


从MOS找到一篇对应的文章:ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2 Database (Doc ID 2127675.1)


分析可能是在建库的时候没有执行dbms_stats.init_package()


$ sqlplus / as sysdba
SQL> 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_created
  2    from sys.wri$_adv_tasks
  3  where owner_name = 'SYS'
  4    and name in ('AUTO_STATS_ADVISOR_TASK','INDIVIDUAL_STATS_ADVISOR_TASK');
 
NAME                                CTIME    HOW_CREATED
----------------------------------- --------- ------------------------------
AUTO_STATS_ADVISOR_TASK            17-JUN-17 CMD
INDIVIDUAL_STATS_ADVISOR_TASK      17-JUN-17 CMD


执行结束后,观察日志,不再继续报错!



编程开发网
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇MySQL分区表使用方法 下一篇PL/SQL Developer连接Oracle 12.2..

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

array(4) { ["type"]=> int(8) ["message"]=> string(24) "Undefined variable: jobs" ["file"]=> string(32) "/mnt/wp/cppentry/do/bencandy.php" ["line"]=> int(214) }