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
