Wednesday, July 04, 2012

Ora-12012: Error On Auto Execute Of Job "Oracle_ocm"."Mgmt_config_job_2_1

OCM job was failing with below error at alert log:
 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 messages happen because of the OCM collection database job is unable to access the directory location where the OCM data is written .
If you do not use OCM delete the OCM configuration from the database:

Log in to your database as user SYS and drop-cascade user ORACLE_OCM:

But if OCM is in use to upload collection to My Oracle Support then it needs reinstrumenting the database.

1. export ORACLE_HOME=
    export ORACLE_SID=

2.  Remove the OCM configuration in the database:

     cd $ORACLE_HOME/ccr/bin
     ./configCCR -r

3. Configure the OCM configuration in the database:

    ./configCCR -a

4.  Instrument the Database:

     cd /ccr/admin/scripts
     ./ collectconfig -s -r SYS

5.  Run a manual collection:

    cd $ORACLE_HOME/ccr/bin
    ./emCCR collect