ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_363" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 49538 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 881 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line...
Platforms : Linux 12.2.0.1 Production SH Solaris 12.2.0.1 Production SH The database alert log contents are: Errors in file /u01/app/oracle/diag/rdbms/orcl/ORCL1/trace/ORCL1_j000_73185.trc: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_936" ORA-20001: Statistics ...
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 关于博主:评论和私信会在第一时间回复。或者直接私信我。
v_tname := 'AUTO_STATS_ADVISOR_TASK';DBMS_STATS.DROP_ADVISOR_TASK(v_tname);END;/ SQL> ...
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 ...
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"
看了一下报错频率,大概是每隔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 Configuration Manager - Version 10.3.8 and later: Database alert_log Shows Error: ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And
Oracle 12.2 报错:ORA-12012: error on auto execute of job “SYS"."ORA$AT_OS_OPT_SY_7458” 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_...
ORA-12012: error on auto execute of job 8898 ORA-20000:ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid ORA-06512: at "SYS.PRVT_ADVISOR", line 1624 ORA-06512: at "SYS.DBMS_ADVISOR", line 186 ...