shutdown abort数据库引发的?ORA-04067、ORA-06508、ORA-04067、ORA-06508处理办法

最新推荐文章于 2024-01-11 14:47:30 发布

cuidiaoyu5058

最新推荐文章于 2024-01-11 14:47:30 发布

阅读量1.2k

点赞数

文章标签：数据库

故障描述：
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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10995764/viewspace-2124025/