【Oracle故障】ORA-07445: [$cold_qerfxArrayMaxSize()+7456] and ORA-00081
数据库经常会出现以下报错信息：ksedmp: internal or fatal errorORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] []word ksmpgf_ ksedmp: errors signalled while dumping diagnosticsORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not readableORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] [] 经过Metalink文档，这是一个Bug，仅见于HP-UX Itanium环境，在Oracle10.2.0.3中修正，一般不会带来严重影响建议安装相应的Patch是： Patch:5442780或者升级数据库版本。 metalink文档描述如下： Bug 5382798 : ORA-7445: EXCEPTION ENCOUNTERED: CORE DUMP [$COLD_QERFXARRAYMAXSIZE()+XXXXX] Abstract: ORA-7445: EXCEPTION ENCOUNTERED: CORE DUMP [$COLD_QERFXARRAYMAXSIZE()+XXXXX] *** 07/10/06 07:37 pm *** PROBLEM: -------- At customer site, ORA-7445 occurs on user processes(ex. datapump) and mmon once a day. . Alert.log ========== : Tue Jun 27 04:22:37 2006 Errors in file /local/tk/log/oracle/mst/udump/tk_mst_ora_15810.trc: ORA-7445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+13776] [SIGSEGV] [Address not mapped to object] [0x00002106C] [] [] : Tue Jun 27 05:00:14 2006 Errors in file /local/tk/log/oracle/mst/bdump/tk_mst_m000_29530.trc: ORA-7445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7264] [SIGSEGV] [Address not mapped to object] [0x000006E7C] [] [] Symptoms:When using the HP Itanium platform, a process may core dump in qerfxArrayMaxSize(), which will be seen in the alert.log as something similar to: ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002B] [] [] The call stack is: ksedst ksedmp ssexhd $cold_qerfxArrayMaxSize qerfxStart Size qerjotFetchqerjotFetch opifch2 opiall0 opikpr opiodr rpidrus skgmstack Sometimes this is accompanied by an: ORA-00081: address range [0x######, 0x######) is not readableCauseThe 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. Solution:Oracle Development has released a patch that contains re-compiled version of the affected module (compiled without the feature that is causing the problem). The patch can be obtained here: Patch:5442780 The 10.2.0.3 patchset is also compiled in this way, and hence the issue is not present in this (or future) versions.