www.eygle.com

« 使用RMAN验证备份的有效性 | Blog首页 | Office、AcitiveSync 以及 我所浪费的时间 »

ORA-07445 cold_qerfxArrayMaxSize 的Bug

客户的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

-The End-

By eygle on 2010-01-26 10:28 | Comments (2) | Posted to Case | Oracle10g/11g | Edit |Pageviews:

相关文章	随机文章
遭遇 ORA-7445 kkofkrproratestat 错误 Oracle 10.2.0.3的Ora-1461 / Smg-3500错误 ORA-07445 kprball()+483错误之原因分析 BUG带来的BUG-kjdrpkey2hv: called with pkey ORA-00600 4000 及 4194 错误小记	工作日志：10 亿记录表的几个索引创建时间 解决VxVM vxdisk ERROR V-5-1-5433 错误 Oracle9i自动PGA管理的新特性 关于恩墨科技第二次培训暂时推迟的通知 DBA警世录:Oracle的共享内存段

留言 (2)

Posted by: dbsnake at February 11, 2010 9:26 AM

Posted by: eygle at February 12, 2010 4:28 PM

发表留言:

Name(*):
Email(*):

You Link: Remember Me? YesNo
验证码(*): (输入验证码后方可评论,谢谢支持)
Comments: