Sunday, February 10, 2013


On a new install following could be observed on the alert log
Errors in file /opt/app/oracle/diag/rdbms/db/db1/trace/db1_j004_5824.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
This is because the OCM is trying to write a directory that doesn't exists and to resolve this the out of the box OCM that comes with installer need further configuration. If OCM is not used drop the OCM user and the default directory setup. This does not affect any other database components.
SQL> drop user ORACLE_OCM cascade;
User dropped.

SQL> drop directory ORACLE_OCM_CONFIG_DIR;
Directory dropped.
If OCM is used then configure it by following "Oracle Configuration Manager Installation and Administration Guide".

Useful metalink notes
How to deinstall OCM [ID 761313.1]
Oracle Configuration Manager FAQ [ID 369111.5]
How To Manually Remove ORACLE_OCM From Database [ID 859113.1]
"ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid directory path" In Database AlertLog [ID 1453959.1]