暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-07445 [LdiInterToArray()+56] [SIGSEGV]

原创 章芋文 2014-06-11
623
1. 节点1出现一次ORA-07445错误
[code]Mon Dec 30 04:05:39 2013
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x974] [PC:0x1068D2058, LdiInterToArray()+56] [flags: 0x0, count: 1]
Errors in file /opt/oracle/app/diag/rdbms/..._q003_18926.trc (incident=610974):
ORA-07445: exception encountered: core dump [LdiInterToArray()+56] [SIGSEGV] [ADDR:0x974] [PC:0x1068D2058] [Address not mapped to object] []
Incident details in: /opt/oracle/app/diag/rdbms/..._q003_18926_i610974.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.[/code]
部分trace文件:
[code]*** 2013-12-30 04:05:39.655
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=5udxh0ykgshkb) -----
select location_name, max(r.reg_id) from reg$ r left outer join gv$subscr_registration_stats v on r.reg_id = v.reg_id where location_name like 'net8://(%' group by location_name having min(current_timestamp-nvl(last_ntfn_sent_time, reg_time)) > :1

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
LdiInterToArray()+5 PTR_CALL 0000000000000000 FFFFFFFF7D600200 ?
6 FFFFFFFF7D600200 ?
FFFFFFFF7A601C10 ?
000000009 ? 000000000 ?
000000000 ?[/code]
在MOS上确认为BUG:1355780,是由于gv$subscr_registration_stats和reg$关联查询引起。MOS上给出的方案有如下2个:
1)、打上7276499补丁,确认有11.2.0.2在solaris上对应的patch;
2)、升级到12.1。
鉴于这个bug只出现过一次,可以再观察一段时间再考虑是否打补丁或者升级。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论