ora-12012: error on auto execute of job oracle_ocm
alert日志中报错如下：
sun mar 30 06:05:40 2014
errors in file /oracle/app/oracle/diag/rdbms/zscims/zscims1/trace/zscims1_j001_15269946.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
数据库版本：oracle database 11g enterprise edition release 11.2.0.3.0 - 64bit production
pl/sql release 11.2.0.3.0 - production
core 11.2.0.3.0 production
tns for ibm/aix risc system/6000: version 11.2.0.3.0 - production
nlsrtl version 11.2.0.3.0 - production
#################
参考mos文档：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)
报错原因是：
newer database releases are automatically instrumented for ocm collections. but here, the ocm instrumentation job is trying to write to a state directory which doesn't yet exists. ---目录不存在
oracle_ocm 账户是用来管理oracle configuration manager的。 默认情况下， 该账户是expired and locked状态。
该错误只出现在oraclerdbms 11.2.0.3 的版本（新安装的db，或者从其他版本升级到11.2.0.3的），或者oracle configuration manager 的版本大于10.3.3.0.0。
to verify the ocm db directories, run as sysdba: ---可以通过下面语句确认下目录是否不存在
sql>select * from dba_directories where directory_name like '%ocm_config%';
mgmt_db_ll_metrics wants to write to oracle_ocm_config_dir2, which is not created by the built-in instrumentation scripts.
如果不需要向mos上传搜集信息，可以删除用户oracle_ocm来解决，语句：
when not using the ocm collector, remove the ocm objects from database:
sql> drop user oracle_ocm cascade;
ocm is a standalone, separate tool and removing won't affect the database functionality.
#####################################
如是10g--version 10.2.3 to 10.3.1,参考mos文档：how to manually remove oracle_ocm from database (文档 id 859113.1)解决方法：
如不需要使用此功能，，可以删除用户oracle_ocmt和相应directory来解决，语句：
in order to manually remove the oracle_ocm user and associated objects from database, run:
sql> drop user oracle_ocm cascade;
sql> drop directory oracle_ocm_config_dir;
本文永久更新链接地址：