Oracle 11.2.0.3 RAC环境--ORA-12012 ,ORA-2928 错误处理

最新推荐文章于 2021-04-08 19:15:48 发布

clep17285

最新推荐文章于 2021-04-08 19:15:48 发布

阅读量164

点赞数

文章标签：数据库

Errors in file /oracle/app/oracle/diag/rdbms/hzwsj/hzwsj1/trace/hzwsj1_j002_8520478.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
Fri May 16 11:16:49 2014
----------------------------------------------文档------------------------------------------
"ORA-12012: error on auto execute of job ORACLE_OCM.MGMT_CONFIG_JOB_2_1" And "ORA-29280: invalid directory path" In Database AlertLog (Doc ID 1453959.1)

Applies to:

Oracle Configuration Manager - Version 10.3.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Following error is reported every 24 hours in the alertLog file of a 11.2.0.3 database:
Errors in file /opt/oracle/diag/rdbms/db/trace/db_j001_26027.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

Changes

Newly installed 11.2.0.3 database, or recently upgraded to 11.2.0.3 from an earlier release.

Cause

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.
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.

Solution

Problem is fixed with OCM Collector version 10.3.7

A. But out-of-box the 11.2 database includes earlier OCM version, therefore one must re-configure database for OCM collections by running the "ORACLE_HOME/ccr/admin/scripts/installCCRSQL" script. If script is missing, first configure OCM by running "ORACLE_HOME/ccr/bin/setupCCR".
Pay attention when on RAC database, with a non-shared file system environment, must set the ORACLE_CONFIG_HOME environment variable to $ORACLE_HOME prior to running the installCCRSQL.sh script. Reference: Oracle Configuration Manager Installation and Administration Guide

B. 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.

Or could simply disable the OCM jobs by running:
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB')
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB')
--------------------------------------------------------------
这个问题在升级之前的11.2.0.2版本上没有出现过，显然这是升级到11.2.0.3带来的bug。而报错的JOB所属用户

ORACLE_OCM是Oracle配置管理的专属用户。根据文档"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]
，导致问题的原因是数据库升级到11.2.0.3后，Oracle会启用自动OCM collection，在这个过程中Oracle尝试使用目录
ORACLE_OCM_CONFIG_DIR2，但这个目录在创建过程中并未建立。
解决该问题并不复杂，对于不需要使用配置管理器的用户而言，可以简单的DISABLE掉这个JOB，或者直接将ORACLE_OCM用
户删除：
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_CONFIG_JOB')
exec dbms_scheduler.disable('ORACLE_OCM.MGMT_STATS_CONFIG_JOB')
如果需要使用配置管理器，可以通过ORACLE_HOME/ccr/admin/scripts/installCCRSQL脚本来重新设置配置管理器。如果上
面的脚本缺失，可以通过先执行ORACLE_HOME/ccr/bin/setupCCR脚本的方式来进行配置。