shutdown abort数据库引发的?ORA-04067、ORA-06508、ORA-04067、ORA-06508处理办法
故障描述：
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;
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博客 ” ，链接：https://blog.itpub.net/10995764/viewspace-2124025/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- DML DDL 都报ORA-00600: [kntgMvLogObjn]的解决办法
- DG逻辑库logstdby 日志应用长时间不归档
- scan-ip连接出现“ORA-12545”
- ORACLE 12C DATAGUARD环境搭建和主从切换
- oracle 11g rac更改public的网卡名称
- oracle??逻辑DG同步卡住,session等待row cache lock的处理过程
- 设置postfix作为邮件发送服务器
- REDHAT6.5上安装 iRedMail-0.9.5 开源邮件服务器安装方案
- oracle 12c ORA-28040: No matching authentication protocol 处理办法
- 运维工作列表
