Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5B] [PC:0x98079B2, kghalp()+46] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/oradbtd/oradbtd/trace/oradbtd_ora_18892.trc (incident=13777):
ORA-07445: exception encountered: core dump [kghalp()+46] [SIGSEGV] [ADDR:0x5B] [PC:0x98079B2] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/oradbtd/oradbtd/incident/incdir_13777/oradbtd_ora_18892_i13777.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue Dec 31 16:16:38 2019
Dumping diagnostic data in directory=[cdmp_20191231161638], requested by (instance=1, osid=18892), summary=[incident=13777].
Tue Dec 31 16:16:39 2019
Sweep [inc][13777]: completed
Sweep [inc2][13777]: completed
这种报错一般是bug导致，MOS没有完全匹配到，但是从trace看可以尝试如下修改：
alter system set “_optimizer_extended_cursor_sharing_rel”=none scope=both;
alter system set “_optimizer_extended_cursor_sharing”=none scope= both;
alter system set “_optimizer_adaptive_cursor_sharing”=false scope= both;
评论
有用 0查询Oracle C函数得知kghalp为：
kghalp: kernel generic heap manager allocate permanent memory
ORA-7445 kghalp的bug还挺多的，ADG上SELECT查询触发的bug比较难排查。
Bug 21157342 - dump on kghalp/_intel_new_memcpy with SQL Monitoring enabled (default) (Doc ID 21157342.8)
上面的bug是指开启sql monitoring后执行长查询会触发这个bug，调用栈为：kghalp <- kghscCopyStream <-keswxCurStartPlanMonitoring，与trace文件中完全一致，但是ADG端理论上不会有这个报错，可以尝试官方给的解决方案：
alter system set "_sqlmon_threshold"=0;
复制也可以尝试不要在ADG上运行太长的SQL，或者提升SQL运行效率，不然也很容易触发ORA-01555错误。
*** 2019-12-31 16:16:36.441
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=b60whdmdxz8qn) -----
select count(1) as IS_HAS from V_PHONEINFO where CONTACT_MOBILE in ( :1 )
kghalp()+46 signal __sighandler() 00C0F8C80 ? 000000000 ?
000000018 ? 000000001 ?
000000000 ? 000000018 ?
kghscAllocDataElem( call kghalp() 00C0F8C80 ? 000000000 ?
)+84 000000018 ? 000000001 ?
000000000 ? 00A96B0C8 ?
kghscWrite()+241 call kghscAllocDataElem( 00C0F8C80 ? 7FFC13F7A0D0 ?
) 122FAE2588 ? 000000001 ?
000000000 ? 00A96B0C8 ?
kghscCopyStream()+8 call kghscWrite() 00C0F8C80 ? 7FFC13F7A0D0 ?
31 122FAE2588 ? 000000001 ?
000000000 ? 00A96B0C8 ?
keswxCurStartPlanMo call kghscCopyStream() 7FFC13F79A00 ? 0000003B8 ?
nitoring()+2352 0000003B8 ? 000000001 ?
000000000 ? 00A96B0C8 ?
keswxCurPushMonitor call keswxCurStartPlanMo 7F8935E19700 ? 7F8935BD4D78 ?
ing()+2357 nitoring() 115E30C910 ? 000000000 ?
000000000 ? 00A96B0C8 ?
kews_sqlst_push_mon call keswxCurPushMonitor 7F8935E19700 ? 000000000 ?
itoring()+504 ing() 000000000 ? 000000001 ?
0001E8507 ? 000000000 ?
kews_sqlst_flush_le call kews_sqlst_push_mon 7F8935E19700 ? 000000000 ?
vel()+338 itoring() 000000000 ? 000000001 ?
0001E8507 ? 000000000 ?
kews_sqlst_flush()+ call kews_sqlst_flush_le 11812C79D0 ? 000000000 ?
382 vel() 116FA1FD38 ? 7F8935FEB9B8 ?
0001E8507 ? 000000000 ?
kews_timeout()+358 call kews_sqlst_flush() 11812C79D0 ? 000000000 ?
116FA1FD38 ? 7F8935FEB9B8 ?
0001E8507 ? 000000000 ?
ksu_dispatch_tac()+ call kews_timeout() 11812C79D0 ? 000000000 ?
1157 116FA1FD38 ? 7F8935FEB9B8 ?
0001E8507 ? 000000000 ?
复制
