ITPUX技术网

交流 . 资讯 . 分享
Make progress together!
Oracle数据库DBA高级工程师培训视频
Oracle数据库培训-备份恢复-性能优化-集群容灾
mysql数据库视频教程

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

内容发布:风哥| 发布时间:2013-12-21 22:43:46
Oracle故障】ORA-07445: [$cold_qerfxArrayMaxSize()+7456] and ORA-00081
数据库经常会出现以下报错信息:
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [$cold_qerfxArrayMaxSize()+7456] [SIGBUS] [Invalid address alignment] [0x00000002C] [] []
word ksmpgf_ ksedmp: errors signalled while dumping diagnostics
ORA-00081: address range [0x60000000000A7D70, 0x60000000000A7D74) is not readable
ORA-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 qerjotFetch
qerjotFetch opifch2 opiall0 opikpr opiodr rpidrus skgmstack Sometimes this is accompanied by an:
ORA-00081: address range [0x######, 0x######) is not readableCause
The 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.


上一篇:【Oracle故障】ORA-00600: internal error code, arguments: [kkslmtl-valnotfound]
下一篇:【Oracle故障】clssnmPollingThread: node test2 (2) missed(2) checkin(s)
189070296,150201289

专业提供Oracle数据库服务、主机、存储、备份、中间件等相关技术支持服务,QQ号:176140749
关注ITPUX技术网微信公众号itpux_com  ,了解本站最新技术资料的分享.

欢迎加QQ群,提供超多高质量Oracle/Unix/Linux技术文档与视频教程的下载。

Oracle/MySQL/Linux群4-5:189070296  150201289  
Oracle/MySQL/Linux群6-8:244609803   522261684   522651731
备注:请勿重复加群,另请注明 from itpux

加群分享视频教程部分如下:

1、公开课视频:Oracle/MySQL数据库工程师职业发展前景讲解(免费)
http://edu.51cto.com/course/7015.html

2、51CTO学院Oracle数据库高级工程师培训(高薪就业.课程介绍)
http://edu.51cto.com/px/train/131?xiaotu

3、Oracle DBA数据库高级工程师培训视频课程1.1(系列78套+七大阶段+上千案例)
套餐视频地址: http://edu.51cto.com/topic/1121.html

4、MySQL数据库(终身门徒)套餐:http://edu.51cto.com/sd/1e1a6

回复

使用道具 举报

内容发布:weitianyi| 发布时间:2015-4-1 15:19:18
安腾 + hpunix 确实不好弄 。
回复 支持 反对

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表