Oracle 11.2.0.3 RAC環境--ORA-12012 ,ORA-2928 錯誤處理
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 laterInformation 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
or
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指令碼的方式來進行配置。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/26764973/viewspace-1218145/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 在Oracle11g RAC環境下處理ORA-00845錯誤案例Oracle
- Oracle RAC 錯誤記錄以及處理方法Oracle
- RAC環境TNS-12541報錯處理
- IIS配置PHP環境HTTP500錯誤處理方法PHPHTTP
- Go多協程併發環境下的錯誤處理Go
- Oracle異常錯誤處理Oracle
- ORACLE 異常錯誤處理Oracle
- Oracle錯誤處理思路(一)Oracle
- 【故障處理】DBCA建庫詭異問題處理--rac環境不能建立rac庫
- RAC 環境Library Cache Lock的處理方法
- oracle ora-00054錯誤處理Oracle
- Oracle 11.2.0.3 ORA-12012 ORA-29280 ORA-06512 錯誤 解決方法Oracle
- RAC環境Library Cache Lock的處理方法(zt)
- 錯誤處理
- Oracle 11g RAC環境下Private IP修改方法及異常處理Oracle
- 【轉】Oracle 11.2.0.3 ORA-12012 ORA-29280 ORA-06512 錯誤解決方法Oracle
- oracle ORA-14452錯誤處理Oracle
- SAP雲平臺CloudFoundry環境裡route 超過quota的錯誤處理Cloud
- iOS - rvm、Ruby環境CocoaPods安裝使用及相關錯誤處理iOS
- oracle rac 環境檢測Oracle
- RAC環境歸檔NFS掛載方式RMAN備份錯誤NFS
- PHP 錯誤處理PHP
- php錯誤處理PHP
- Go 錯誤處理Go
- Swift錯誤處理Swift
- Zabbix錯誤處理
- mysqldump錯誤處理MySql
- 【問題處理】Windows環境下exp備份資料ORA-00904錯誤處理一例Windows
- 總結:整理 oracle異常錯誤處理 .Oracle
- ORACLE ORA-03137錯誤處理Oracle
- oracle ORA-14452錯誤處理例程Oracle
- ORACLE RAC 環境下修改IPOracle
- Oracle RAC + Data Guard 環境搭建Oracle
- 【Oracle】 RAC 環境刪除oracle 之二Oracle
- 【Oracle】 RAC 環境刪除oracle 之一Oracle
- 錯誤處理:如何通過 error、deferred、panic 等處理錯誤?Error
- PHP錯誤處理和異常處理PHP
- go的錯誤處理Go