0

ORA-07445 [kglnpfr()+24]

问题归档 2019-05-11
58
摘要:数据版本11.2.03出现ora-07445 address not mapped 卡死,在mos是上也搜索不相关ora07445

问题描述

数据版本11.2.03出现ora-07445 address not mapped 卡死,在mos是上也搜索不相关ora07445

[09:02:42]Errors in file /oraclu/app/oracle/diag/rdbms///trace/_pmon_32637454.trc  (incident=10048908):
[09:02:42]ORA-07445: exception encountered: core dump [kglnpfr()+24] [SIGSEGV] [ADDR:0xFFFFFFFFDFFFFB0] [PC:0x10124B218] [Address not mapped to object] []
[09:02:42]Incident details in: /oraclu/app/oracle/diag/rdbms///incident/incdir_10048908/_pmon_32637454_i10048908.trc

专家解答

通过云平台内OraC函数功能查询kgl开头为kernel generic library cache management,也就是library cache相关的问题,查看trace文件中调用栈发现大量的kglnpfr()+48调用kglnpfr(),且存在kglMutexCleanupAll,应该是清理内存中Mutex的操作

Dump continued from file: /oraclu/app/oracle/diag/rdbms///trace/_pmon_32637454.trc
ORA-07445: exception encountered: core dump [kglnpfr()+24] [SIGSEGV] [ADDR:0xFFFFFFFFDFFFFB0] [PC:0x10124B218] [Address not mapped to object] []
========= Dump for incident 10048908 (ORA 7445 [kglnpfr()+24]) ========
----- Beginning of Customized Incident Dump(s) -----
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0xFFFFFFFFDFFFFB0] [PC:0x10124B218, kglnpfr()+24] [flags: 0x0, count: 1]
Registers:
iar: 0x000000010124b218  lr: 0x000000010124b234
msr: 0xa00000000000d032  cr: 0x0000000044242204
r00: 0x0700002704d946c8 r01: 0x0ffffffffe000040 r02: 0x0000000110659f58
r03: 0x0000000110000198 r04: 0x0700000000000198 r05: 0x070000271c9108f0
r06: 0x00000000000009d8 r07: 0x0000000000000010 r08: 0x0700000000107868
r09: 0x0000000000000002 r10: 0x0000000000000002 r11: 0x0000000000000000
r12: 0x000000010125bd40 r13: 0x00000001106fa8a0 r14: 0x0000000109dfb738
r15: 0x0ffffffffffff998 r16: 0x0ffffffffffff9a8 r17: 0x0800200140000000
r18: 0x0ffffffffffffed0 r19: 0x09fffffff000d4d0 r20: 0x0000000109dfcae4
r21: 0x0000000109dfcacc r22: 0x0000000000000000 r23: 0x07000027909ae9a8
r24: 0x0000000000000001 r25: 0x000000010b0c63e0 r26: 0x0000000000000002
r27: 0x0700000000003668 r28: 0x0000000000000000 r29: 0x070000270279df88
r30: 0x07000026995d5dd8 r31: 0x070000270c199560 
*** 2019-04-23 08:45:20.605
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- SQL Statement (None) -----
Current SQL information unavailable - no cursor.
----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
skdstdst()+40        bl       107c4f05c            000000000 ? 000000001 ?
                                                   000000003 ? 000000001 ?
                                                   000000000 ? 000000001 ?
                                                   000000003 ? 000000001 ?
ksedst1()+112        call     skdstdst()           1597F3DB8F312652 ?
                                                   4824384100000000 ?
                                                   11088CE30 ? 000002004 ?
                                                   1106FE9A0 ? 10A3AB18C ?
                                                   000000000 ? 1106FE9A0 ?
ksedst()+40          call     ksedst1()            303106FE9A0 ? 002050033 ?
                                                   10A3AB180 ? 7000000000262 ?
                                                   000000000 ? 000000000 ?
                                                   10A3AA780 ? 000000000 ?
dbkedDefDump()+1516  call     ksedst()             000000008 ? 110000A5C ?
                                                   000000000 ? 110000A5C ?
                                                   7100000000000000 ?
                                                   000000000 ? 1108C41B8 ?
                                                   300000003 ?
ksedmp()+72          call     dbkedDefDump()       300000000 ? 063313939 ?
                                                   10124B218 ? 000000001 ?
                                                   00000000B ? 11088DB10 ?
                                                   11088DDC0 ? 000000001 ?
ssexhd()+2672        call     ksedmp()             109E2B3E0 ? 200000002 ?
                                                   000000004 ? 000000000 ?
                                                   000000004 ? 000000001 ?
                                                   02B32345D ? 000000000 ?
47dc                 call     ssexhd()             000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     47dc                 000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     kglnpfr()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     kglnpfr()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     kglnpfr()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     kglnpfr()            000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
                                                   000000000 ? 000000000 ?
kglnpfr()+48         call     kglnpfr()            000000000 ? 000000000 ?

官方资料表示这是很少遇见的Shared pool坏块,目前没有临时解决方案,只能通过升级解决,且至少升级到11.2.0.4.161018。

不过可以尝试刷共享池或者重启试试,ps:生产环境慎用。

「喜欢文章,快来给作者赞赏墨值吧」

评论

0
0
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部
暂无课程,敬请期待...