ORA-07445: exception encountered: core dump

谈笑DataBase

于 2015-02-28 16:14:18 发布

阅读量1.9k

点赞数

CC 4.0 BY-SA版权

分类专栏： Oracle TroubleShooting

本文链接：https://blog.youkuaiyun.com/talkingDB/article/details/43986933

博客内容描述了遇到Oracle数据库出现ORA-07445错误，详细报错信息显示为core dump，与SGA内存腐败相关。该问题在Oracle 9i Enterprise Edition Release 9.2.0.6.0中出现，并且在高并发情况下发生。通过查看进程状态和错误日志，分析出可能由于Bug 3949307导致。解决方案是将数据库版本升级到9.2.0.7来修复此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-07445: exception encountered: core dump [kgldtin()+1072] [SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []

报错
Errors in file /oracle/product/9.2.0/rdbms/log/afcc_ora_7648.trc:
ORA-07445: exception encountered: core dump [kgldtin()+1072] [SIGSEGV] [Invalid permissions for mapped object] [0x000000000] [] []

call stack: kgldtin <- kgldti <- kkdlgob <- qcsfgob <- qcsprfro <- qcspafq

现象
高峰期经常I/O 100%,不停写trc，最后爆掉

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

因为 Bug:3949307 " SGA memory corruption / OERI:KGHALO4 with high concurrency". 而引起的。

ROCESS STATE
-------------
Process global information:
process: c00000053c3b3ce8, call: c00000053c5a9c80, xact: 0000000000000000, curses: c00000053a3ca618, usrses: c00000053a3ca618
-