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:

SQL> DROP USER ORACLE_OCM CASCADE;

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

     ./installCCRSQL.sh collectconfig -s -r SYS

5.  Run a manual collection:

    cd $ORACLE_HOME/ccr/bin

    ./emCCR collect