Oracle 11.2.0.3 RAC environment ORA-29280 error Solution

Oracle 11.2.0.3 RAC environment ORA-29280 error solution the customer's 11.2.0.3 RAC environment automatically runs the JOB reports an error ORA-29280. Detailed error message for www.2cto.com: Sat Sep 15 05:59:59 2012 VKRM started with pid = 54, OS id = 32622 Sat Sep 15 06:00:09 2012 Errors in file/opt/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_j001_32634.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 www.2cto.com this issue prior to upgrade No error occurred in version 11.2.0.2. This is obviously a bug caused by upgrading to version 11.2.0.3. ORACLE_OCM is the exclusive user of Oracle configuration management. According to the document "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], the cause is that after the Database is upgraded to 11.2.0.3, oracle will enable automatic OCM collection. In this process, Oracle tries to use the ORACLE_OCM_CONFIG_DIR2 directory, but this directory is not created during the creation process. It is not complicated to solve this problem. For users who do not need to use the Configuration Manager, they can simply DISABLE the JOB or directly Delete the ORACLE_OCM User: exec dbms_scheduler.disable ('oracle _ OCM. MGMT_CONFIG_JOB ') exec dbms_scheduler.disable ('oracle _ OCM. MGMT_STATS_CONFIG_JOB ') if you need to use the Configuration Manager, you can use the ORACLE_HOME/Cr/admin/scripts/installCCRSQL script to reset the Configuration Manager. If the preceding script is missing, you can configure it by executing the ORACLE_HOME/Cr/bin/setupCCR script first.