问题描述
客户的10.2.0.2数据库遇到了这样一个问题:
Sat Jan 23 02:01:00 2010 Errors in file /CMP/saptrace/background/cmp_m000_26819.trc: ORA-00081: address range [0x600000000009C450, 0x600000000009C454) is not readable ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] []
专家解答
经过Metalink文档:386727.1 确认,这是一个Bug,仅见于HP-UX Itanium环境,在10.2.0.3中修正,一般不会带来严重影响。
在跟踪文件中记录了更为详尽的信息:
ksedmp: internal or fatal error ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] [] Current SQL statement for this session: INSERT INTO wrh$_bg_event_summary (snap_id, dbid, instance_number, event_id, total_waits, total_timeouts, time_waited_micro) SELECT /*+ ORDERED USE_NL(E) */ :snap_id, :dbid, :instance_number, e.event_id, SUM (e.total_waits), SUM (e.total_timeouts), SUM (e.time_waited_micro) FROM v$session bgsids, v$session_event e WHERE bgsids.TYPE = 'BACKGROUND' AND bgsids.SID = e.SID GROUP BY e.event_id
不同的环境触发的SQL可能不同,但是通常ORA-07445和ORA-00081同时出现。
这是由于C编译器的问题导致的:
The problem is reported in <<bug:5382798>> and found to be an issue with the C compiler used on HP Itanium to compile the Oracle 10.2 code.
相应的Patch是: Patch:5442780
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。