手机版
你好,游客 登录 注册
背景:
阅读新闻

Oracle 12.2 报错:ORA-12012: error on auto execute of job “SYS"."ORA$AT_OS_OPT_SY_7458”

[日期:2019-01-13] 来源:Linux社区  作者:abclife [字体: ]

alert报错

2019-01-12T10:10:11.499130+08:00
Errors in file /u01/app/Oracle/diag/rdbms/rac1/rac112/trace/rac112_j000_119621.trc:
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7458"
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
查看trc文件

more /u01/app/oracle/diag/rdbms/rac1/rac112/trace/rac112_j000_23470.trc
Trace file /u01/app/oracle/diag/rdbms/rac1/rac112/trace/rac112_j000_23470.trc
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Build label:    RDBMS_12.2.0.1.0_LINUX.X64_170125
ORACLE_HOME:    /u01/app/oracle/product/12.2.0.1/dbhome_1
System name:    Linux
Node name:    exa02
Release:    4.1.12-94.8.5.el6uek.x86_64
Version:    #2 SMP Wed Jul 11 12:03:41 PDT 2018
Machine:    x86_64
Storage:    Exadata
Instance name: rac112
Redo thread mounted by this instance: 2
Oracle process number: 512
Unix process pid: 23470, image: oracle@exa02 (J000)


*** 2019-01-12T09:29:47.002259+08:00 (CDB$ROOT(1))
*** SESSION ID:(3880.47911) 2019-01-12T09:29:47.002289+08:00
*** CLIENT ID:() 2019-01-12T09:29:47.002296+08:00
*** SERVICE NAME:(SYS$USERS) 2019-01-12T09:29:47.002303+08:00
*** MODULE NAME:(DBMS_SCHEDULER) 2019-01-12T09:29:47.002309+08:00
*** ACTION NAME:(ORA$AT_OS_OPT_SY_7436) 2019-01-12T09:29:47.002316+08:00
*** CLIENT DRIVER:() 2019-01-12T09:29:47.002322+08:00
*** CONTAINER ID:(1) 2019-01-12T09:29:47.002328+08:00
 
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_7436"
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

--解决方法

sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sat Jan 12 10:17:11 2019

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> 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');
 
no rows selected
 
SQL> EXEC dbms_stats.init_package();
 
PL/SQL procedure successfully completed.
 
SQL> 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');
 
NAME
--------------------------------------------------------------------------------
CTIME      HOW_CREATED
--------- ------------------------------
AUTO_STATS_ADVISOR_TASK
12-JAN-19 CMD

INDIVIDUAL_STATS_ADVISOR_TASK
12-JAN-19 CMD

更多Oracle相关信息见Oracle 专题页面 https://www.linuxidc.com/topicnews.aspx?tid=12

Linux公社的RSS地址https://www.linuxidc.com/rssFeed.aspx

本文永久更新链接地址https://www.linuxidc.com/Linux/2019-01/156319.htm

linux
相关资讯       ORA-12012 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款