ORA-07445: exception encountered: core dump

最新推荐文章于 2023-10-13 19:11:03 发布

原创

最新推荐文章于 2023-10-13 19:11:03 发布 · 2k 阅读

1 ·

CC 4.0 BY-SA版权

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

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
-