shutdown abort資料庫引發的?ORA-04067、ORA-06508、ORA-04067、ORA-06508處理辦法

gxlineji發表於2016-08-25
故障描述:
shutdown abort 資料庫後,資料庫起不來。

檢視alert日誌log.xml,報如下錯誤:
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+754] [SIGSEGV] [ADDR:0xD8] [PC:0x93F1E2C] [Address not mapped to object] []
ORA-04067: not executed, package body "OGG.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "OGG.DDLREPLICATION"
ORA-04067: not executed, package body "OGG.DDLREPLICATION" does not exist
ORA-06508: PL/SQL: could not find program unit being called: "OGG.DDLREPLICATION"

解決辦法:
使用oracle隱含引數,禁止觸發器,啟動後,再開啟觸發器。
步驟:
startup mount 
ALTER SYSTEM SET _system_trig_enabled=FALSE SCOPE=MEMORY;
alter database open;

ALTER SYSTEM SET _system_trig_enabled=TRUE SCOPE=MEMORY;


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10995764/viewspace-2124025/,如需轉載,請註明出處,否則將追究法律責任。

相關文章