ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+15264]

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

1. Wed Jun 10 10:06:35 2015
   
2. Errors in file /oracle/CQP/saptrace/usertrace/cqp_ora_11958.trc:
   
3. ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+12496] [SIGBUS] [Invalid address alignment] [0x000000029] [] []
   
4. Wed Jun 10 10:06:42 2015
   
5. Errors in file /oracle/CQP/saptrace/usertrace/cqp_ora_11958.trc:
   
6. ORA-00081: address range [0x600000000009C3B0, 0x600000000009C3B4) is not readable
   
7. ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+12496] [SIGBUS] [Invalid address alignment] [0x000000029] [] []

     trace文件相关内容如下：

1. ksedmp: internal or fatal error
   
2. ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] []
   
3. Current SQL statement for this session:
   
4. SELECT 'OracleConnectSessionNUM', count(*) "SessionCount" FROM v$session
   
5. ----- Call Stack Trace -----
   
6. calling call entry argument values in hex
   
7. location type point (? means dubious value)
   
8. -------------------- -------- -------------------- ----------------------------
   
9. ksedst()+64 call _etext_f()+23058430 000000001 ? 000000001 ?
   
10.                               09029022096
    
11. ksedmp()+1680 call _etext_f()+23058430 000000001 ?
    
12.                               09029022096 C000000000000D20 ?
    
13.                                                    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或以上版本。
    

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29821678/viewspace-1744597/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29821678/viewspace-1744597/