You are currently browsing the tag archive for the ‘ORA-12012’ tag.
I got this error at alertlog on Oracle 18c Database.
Complete errors are:
There is an error in the Oracle alert log file!\n
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_111029″
ORA-20001: Statistics Advisor: Invalid task name for the current user
ORA-06512: at “SYS.DBMS_STATS”, line 49565
ORA-06512: at “SYS.DBMS_STATS_ADVISOR”, line 881
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 21631
ORA-06512: at “SYS.DBMS_STATS_INTERNAL”, line 23763
ORA-06512: at “SYS.DBMS_STATS”, line 49553
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.trc
ORA-12012: error on auto execute of job “SYS”.”ORA$AT_SA_SPC_SY_56337″
ORA-00060: deadlock detected while waiting for resource
ORA-06512: at “SYS.DBMS_SPACE”, line 2741
ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 716
ORA-06512: at “SYS.DBMS_HEAT_MAP_INTERNAL”, line 1164
ORA-06512: at “SYS.DBMS_HEAT_MAP”, line 228
ORA-06512: at “SYS.DBMS_SPACE”, line 2747
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 advisor. This procedure is executed during database creation. If something went wrong during database creation,(for example, init_package is not called for some reason), this kind of errors may be seen in alert log when auto job tries to execute.
So than what is the solution. Here are the steps
Helios's Blog 