客戶遭遇ORA-600 [Kjbrchkpkeywait:Timeout]引起例項down

paulyibinyi發表於2010-10-09
AI

   今天幫客戶分析資料庫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 

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=""+
		 "?db=NOT&id="+docid;
	     window.open(loc,tgt)
	     return;
	   }
	 }
	 Known Bugs

NBBugFixedDescription
11.2.0.2, 12.1.0.0OERI [kjbrchkpkeywait:timeout] in RAC 
11.2.0.2, 12.1.0.0OERI [kjbrchkpkeywait:timeout] in RAC 
10.2.0.4, 11.1.0.6OERI[kclcls_8] or OERI[Kjbrchkpkeywait:Timeout] can occur in RAC 
10.2.0.5, 11.1.0.6OERI[kjbrchkpkeywait:timeout] possible in RAC

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/7199859/viewspace-675647/，如需轉載，請註明出處，否則將追究法律責任。

相關文章