在做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或以上版本。
: