ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 客户遭遇ORA-600 [Kjbrchkpkeywait:Timeout]引起实例down

客户遭遇ORA-600 [Kjbrchkpkeywait:Timeout]引起实例down

原创 Linux操作系统 作者:paulyibinyi 时间:2010-10-09 23:58:24 0 删除 编辑

   今天帮客户分析数据库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]

 

  修改时间 25-AUG-2010     类型 REFERENCE     状态 PUBLISHED  

Note: For additional ORA-600 related information please read Note:146580.1

PURPOSE:
  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;
	   }
	 }
	 Known Bugs
NBBugFixedDescription
921119311.2.0.2, 12.1.0.0OERI [kjbrchkpkeywait:timeout] in RAC
865288911.2.0.2, 12.1.0.0OERI [kjbrchkpkeywait:timeout] in RAC
516588510.2.0.4, 11.1.0.6OERI[kclcls_8] or OERI[Kjbrchkpkeywait:Timeout] can occur in RAC
569467210.2.0.5, 11.1.0.6OERI[kjbrchkpkeywait:timeout] possible in RAC

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

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    907
  • 访问量
    6894208