ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_in 12.2 Database (Doc ID 2127675.1) __EOF__ 本文作者:syksky 本文链接:https://www.cnblogs.com/syksky/p/17748662.html 关于博主:评论和私信会在第一时间回复。或者直接私信我。
Errorsinfile /home/u01/app/oracle/diag/rdbms/xxx/xxx/trace/xxx_j000_106602.trc: ORA-12012: error on auto execute of job"SYS"."ORA$AT_OS_OPT_SY_128403" ORA-20001: Statistics Advisor: Invalid task nameforthe current user ORA-06512: at"SYS.DBMS_STATS", line 47207 ORA-06512: at"SYS.D...
v_tname := 'AUTO_STATS_ADVISOR_TASK';DBMS_STATS.DROP_ADVISOR_TASK(v_tname);END;/ SQL> ...
ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_936" 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...
ALERT日志中报错如下: Sun Mar 30 06:05:40 2014 Errors in file /oracle/app/oracle/diag/rdbms/zscims/zscims1/trace/zscims1_j001_15269946.trc: ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1" ORA-29280: invalid directory path ...
看了一下报错频率,大概是每隔10分钟报一次。该库是12.2.0.1的CDB,其中还有两个pdb。 从MOS找到一篇对应的文章:ORA-12012Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2 Database (Doc ID 2127675.1) 分析可能是在建库的时候没有执行dbms_stats.init_package() ...
Oracle Database - Personal Edition - Version 12.2.0.1 and later: Database alert log shows ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_xx"
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: StatisticsAdvisor: Invalid task name for the current user ORA-06512: at "SYS.DBM...
计划任务有问题。。。估计是你的数据过不了约束条件constraint (CCCC.SYS_C00148570) violated
Oracle Database - Standard Edition - Version 12.2.0.1 and later: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN>" and "ORA-20001: Statistics Adv