ORA-07445:exceptionencountered:coredump[$cold_qerfxArra

在做Oracle数据库巡检时发现数据库的alert日志中出现很多的如下报错：ORA-07445: exception encountered: core dump [$cold_qerf

在做Oracle数据库巡检时发现数据库的alert日志中出现很多的如下报错：

Wed Jun 10 10:06:35 2015

Errors in file /oracle/CQP/saptrace/usertrace/cqp_ora_11958.trc:

ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+12496] [SIGBUS] [Invalid address alignment] [0x000000029] [] []

Wed Jun 10 10:06:42 2015

Errors in file /oracle/CQP/saptrace/usertrace/cqp_ora_11958.trc:

ORA-00081: address range [0x600000000009C3B0, 0x600000000009C3B4) is not readable

ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+12496] [SIGBUS] [Invalid address alignment] [0x000000029] [] []
trace文件相关内容如下：

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:

SELECT 'OracleConnectSessionNUM', count(*) "SessionCount" FROM v$session

----- Call Stack Trace -----

calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- -------------------- ----------------------------

ksedst()+64 call _etext_f()+23058430 000000001 ? 000000001 ?

09029022096

ksedmp()+1680 call _etext_f()+23058430 000000001 ?

09029022096 C000000000000D20 ?

400000000518E470 ?

ORA-07445这个是与ORA-00600其名的错误，MOS上特别为ORA-600、ORA-7445、ORA-700设置了检索入口，参见MOS 153788.1，但这次的7445错误没能在这个入口找到。该错误为oracle 10.2版本在HP Itanium平台的BUG，BUG号bug:5382798，，原因是由于在使用HP Itanium平台的C编译器编译oracle 10.2代码时出现异常，具体说明请参考MOS 386727.1。oracle已经为该BUG发布了patch，如果出现上述错误，建议安装对应的patch，也可以将数据库升级到10.2.0.3或以上版本。

本文永久更新链接地址：