Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Ora-12012, Ora-29280 errors relate to Oracle configuration manager (OCM). Typically, OCM jobs fail due to the old installation after database upgrade operations. Possible errors will be as follows.
1 2 3 4 | 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 |
There are two alternative methods for the solution:
- First of all, if OCM is required, it needs to be uninstalled and reinstalled.
- If not, you can either drop the ORACLE_OCM user to completely remove the OCM-related configuration from your database, or disable the related jobs as follows.
Drop User:
1 | SQL> drop user ORACLE_OCM cascade; |
Disable Job:
1 2 3 4 | SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB'); PL/SQL procedure successfully completed. SQL> exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB'); PL/SQL procedure successfully completed. |
