Oracle数据库出现ORA-600 [Kjbrchkpkeywait:Timeout]引起实例宕机

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

Oracle数据库出现ORA-600 [Kjbrchkpkeywait:Timeout]引起实例宕机

[table=98%]
[td=4,1]今天帮客户分析数据库down机问题,环境oracle 10.2.0.3 rac + aix 2节点down机问题主要原因是:数据库后台日志不断报ORA-600 [kjbrchkpkeywait:timeout]错误,产生非常多的trace文件,导致/oracle文件系统满,从而数据库实例abort,通过清除trace文件,启动数据库实例正常,可以确定是由于bug触发引起,以下为metalink解释ORA-600 [kjbrchkpkeywait:timeout] [ID 465531.1][td=2,1]
[td=6,1]
[td=2,1,25%][td=3,1,50%][i]修改时间 25-AUG-2010 [i]类型 REFERENCE [i]状态 PUBLISHED

[font=Courier New, Courier, mono]Note: For additional ORA-600 related information please read Note:146580.1PURPOSE: This article represents a partially published OERI note. It has been published because the ORA-600 error has been reported in at least one confirmed bug. Therefore, the SUGGESTIONS section of this article may help in terms of identifying the cause of the error. This specific ORA-600 error may be considered for full publication at a later date. If/when fully published, additional information will be available here on the nature of this error.SUGGESTIONS: If the Known Issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to Oracle Support Services for further analysis. Known Issues: function getdoc(docstr) { pos=docstr.indexOf(':'); docid=docstr.substring(pos+1,docstr.length); tgt="_self"; if ( location.href.slice(7,12) == "webiv" || location.href.slice(7,11) == "rmsu" ) { loc="Get?WwwID=note:" + docid; window.open(loc,tgt) return; } if ( location.href.slice(7,12) == "metal" || location.href.slice(7,12) == "suppo" ) { loc="showdoc?db=NOT&id=" + docid; window.open(loc,tgt) return; } else { loc="http://metalink.oracle.com/metalink/plsql/showdoc"+ "?db=NOT&id="+docid; window.open(loc,tgt) return; } }

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