问题描述
数据版本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：生产环境慎用。
最后修改时间：2019-05-17 09:15:48
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
