ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"
發現有一個報表資料庫alert日誌近來每天晚上報如下錯誤:
Errors in file /opt/app/oracle/diag/rdbms/swdb/swdb2/trace/swdb2_j001_8679.trc:
ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"
ORA-29280: invalid directory path
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
看來是執行某個系統job時,伺服器上某個directory有問題導致,那究竟是什麼呢?
檢視metalink文章,DocID 1615561.1
根據文章的意思,發現我伺服器上確實缺少目錄/opt/app/oracle/11.2.0/ccr/state。
根據solution提供的辦法,將問題解決。
Errors in file /opt/app/oracle/diag/rdbms/swdb/swdb2/trace/swdb2_j001_8679.trc:
ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_2"
ORA-29280: invalid directory path
ORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436
看來是執行某個系統job時,伺服器上某個directory有問題導致,那究竟是什麼呢?
檢視metalink文章,DocID 1615561.1
根據文章的意思,發現我伺服器上確實缺少目錄/opt/app/oracle/11.2.0/ccr/state。
根據solution提供的辦法,將問題解決。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/12129601/viewspace-1136274/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-12012: error on auto execute of job "ORACLE_OCMErrorOracle
- ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"ErrorOracle
- ORA-12012: error on auto execute of job 8913Error
- ORA-12012: error on auto execute of job 388947Error
- ORA-12012: error on auto execute of job "SYS"."ORA$AT_SA_SPC_SY_%"Error
- "ORA-12012:error on auto execute of job ORACLE_OCM.ORA-29280"_1453959.1ErrorOracle
- error on auto execute of job "SYS"."PURGE_LOG"錯誤分析Error
- Oracle 12.2 報錯:ORA-12012: error on auto execute of job “SYS”.”ORA$AT_OS_OPT_SY_7458″OracleError
- Oracle 11g報錯"ORA-12012: error on job ORACLE_OCM.MGMT_CONFIG_JOB_2_1"OracleError
- ORA-12012 job解決
- 資料庫JOB 裡的EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS()資料庫AINaN
- [重慶思莊每日技術分享]-12.2 Auto Space Advisor Job Fails ORA-12012,ORA-00060AI
- EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS佔用大量資源AINaN
- 關於EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS()的問題AINaN
- Last_SQL_Error: Could not execute Update_rows eventASTSQLError
- oracle10g最佳化:emd_maintenance.execute_em_dbms_job_procsOracleAINaN
- ERROR 1661 (HY000): Cannot execute statement: impossible to write to binaryError
- Disable the Evolve Job SYS_AUTO_SPM_EVOLVE_TASK in Oracle 12cOracle
- Job: TO_CHAR(CURRENT_TIMESTAMP, 'HH24MISSFF') errorError
- The Execute Disable/No Execute CPU feature is not enabled for this machineMac
- Export and import right application or execute import imp-00010 error solveExportImportAPPError
- Python程式碼解析: job = next(job for job in jobs if job.job_id == job_id)Python
- Job for mysqld.service failed because the control process exited with error code...MySqlAIError
- ORA-39097: Data Pump job encountered unexpected error -12801Error
- mongodb錯誤解決辦法-bash: ./mongod: cannot execute binary file: Exec format errorMongoDBORMError
- VMware: ESXi requires the Execute Disable/No Execute CPU feature to be enabledUI
- SQL Server 2000 Error 14274 ,不能刪除job解決方法SQLServerError
- java cmd executeJava
- Android Auto-Building Apps for Auto,Getting Started with AutoAndroidUIAPP
- 【Oracle】ORA-12012Oracle
- Percona MySQL 5.6 語句加鎖報錯"ERROR 1665 (HY000): Cannot execute statement"MySqlError
- java.io.IOException: Error opening job jar: hadoop-0.20.2-examples.jarJavaExceptionErrorJARHadoop
- Execute to Parse 指標指標
- Job for mysqld.service failed because the control process exited with error code錯誤解決MySqlAIError
- Centos httpd模組 Job for httpd.service failed because the control process exited with error code.CentOShttpdAIError
- oracle建立job並執行jobOracle
- 【JOB】Oracle JOB全面學習(DBMS_JOB和DBMS_SCHEDULER)Oracle
- auto型別型別