【Oracle故障】ORA-07445: [$cold_qerfxArrayMaxSize()+7456] and ORA-00081

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:151

【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.

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】