ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"

ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"

今天在检查时候发现alert日志中有此问题，经查询此job不需要执行也无所谓

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

OCM is the Oracle Configuration Manager, a tool to proactively monitor your Oracle environment to provide this information to Oracle Software Support. As OCM is installed by default in many databases but is some sort of independent from the database's version you won't expect any issues during or after a database upgrade

ORACLE_OCM用户默认是非管理员用户，是过期和锁定状态，官方定义

The account used with Oracle Configuration Manager. This feature enables you to associate the configuration information for the current Oracle Database instance with OracleMetaLink. Then when you log a service request, it is associated with the database instance configuration information.

See Oracle Database Installation Guide for your platform.

如果不需要此用户可以执行

drop user ORACLE_OCM cascade;

如果不让执行job可以执行

exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB');

exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB');

job具体名字可以通过一下查询找到

select t.job_name,
t.job_type,
t.job_action,
t.enabled,
t.state
from dba_scheduler_jobs t
where t.owner = 'ORACLE_OCM';

查看然后如果像创建目录，执行

ORACLE_HOME/ccr/admin/scripts/installCCRSQL
查询目录

select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';

MGMT_DB_LL_METRICS需要写入目录：ORACLE_OCM_CONFIG_DIR2