oracle的12012,Oracle12.2报错：ORA12012:erroronautoexecuteofjob“SYS＂.＂ORA$AT_OS_OPT_SY_7458”...

alert报错

2019-01-12T10:10:11.499130&＃43;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&＃64;exa02 (J000)

*** 2019-01-12T09:29:47.002259&＃43;08:00 (CDB$ROOT(1))

*** SESSION ID:(3880.47911) 2019-01-12T09:29:47.002289&＃43;08:00

*** CLIENT ID:() 2019-01-12T09:29:47.002296&＃43;08:00

*** SERVICE NAME:(SYS$USERS) 2019-01-12T09:29:47.002303&＃43;08:00

*** MODULE NAME:(DBMS_SCHEDULER) 2019-01-12T09:29:47.002309&＃43;08:00

*** ACTION NAME:(ORA$AT_OS_OPT_SY_7436) 2019-01-12T09:29:47.002316&＃43;08:00

*** CLIENT DRIVER:() 2019-01-12T09:29:47.002322&＃43;08:00

*** CONTAINER ID:(1) 2019-01-12T09:29:47.002328&＃43;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 &＃61; &＃39;SYS&＃39;

and name in (&＃39;AUTO_STATS_ADVISOR_TASK&＃39;,&＃39;INDIVIDUAL_STATS_ADVISOR_TASK&＃39;);

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 &＃61; &＃39;SYS&＃39;

and name in (&＃39;AUTO_STATS_ADVISOR_TASK&＃39;,&＃39;INDIVIDUAL_STATS_ADVISOR_TASK&＃39;);

NAME

--------------------------------------------------------------------------------

CTIME      HOW_CREATED

--------- ------------------------------

AUTO_STATS_ADVISOR_TASK

12-JAN-19 CMD

INDIVIDUAL_STATS_ADVISOR_TASK

12-JAN-19 CMD