ORA-12012
-
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_**”
I got this error at alertlog on Oracle 18c Database.Complete errors are: There is an error in the Oracle alert log file!\nORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_111029″ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at “SYS.DBMS_STATS”, line 49565ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 881ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21631ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 23763ORA-06512: at Continue reading
-
12.2 space advisor job fails with ORA-12012 and ORA-00060:
Hi friends… One of our 12.2 db we got below errors from alertlog: ORA-00060: deadlock resolved; details in file /u01/app/oracle/diag/rdbms/db_name/DB_NAME/trace/DB_NAME_j001_10041.trcORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_56337″ORA-00060: deadlock detected while waiting for resourceORA-06512: at “SYS.DBMS_SPACE”, line 2741ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 716ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 1164ORA-06512: at “SYS.DBMS_HEAT_MAP”, line 228ORA-06512: at “SYS.DBMS_SPACE”, line 2747 Continue reading
-
ORA-12012 Error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY
In Our 18.3 RAC database, I noticed that below error in alertlog file. Errors in file /u01/app/oracle/diag/rdbms/sid/instance1/trace/instance1_j002_11339.trc: ORA-12012: error on auto execute of job “ORACLE_OCM”.”MGMT_CONFIG_JOB_2_1″ ORA-29280: invalid directory path ORA-06512: at “ORACLE_OCM.MGMT_DB_LL_METRICS”, line 2436 ORA-06512: at line 1 Seed database was most likely not created right by package dbms_stats.init_package not being ran. Dbms_stats.init_package creates statistics Continue reading
HELIOS BLOG 