eygle.com   eygle.com
eygle.com eygle
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-


历史上的今天...
    >> 2007-01-26文章:
           Metalink的替代访问站点
    >> 2006-01-26文章:
           Oracle7.3.4数据库已经启动
    >> 2005-01-26文章:
           HP-Unix中的时区设置

无觅

By eygle on 2010-01-26 10:28 | Comments (2) | Case | Oracle12c/11g | 2498 |

2 Comments

给大师拜个早年哈,祝虎年大吉!


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com