« 使用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) | Case | Oracle12c/11g | 2498 |

Bugoerror