ORA-600 [kjbrchkpkeywait:timeout]

zwunixdb發表於2013-10-30
AI
一大早接到報障，後臺發現出現很多ORA-600 [kjbrchkpkeywait:timeout] 錯誤，該錯誤由insert插入分割槽表的sql引起。MOS上很多關於該類錯誤屬於BUG的解析。
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.


ERROR:
  Format: ORA-600 [kjbrchkpkeywait:timeout] [a] [b] [c] [d] [e]
          

The list below is restricted to show only bugs believed to affect version 11.2.0.3.
Other bugs may affect this version but have not been confirmed as being relevant yet.

There are 3 bugs listed.
NBBugFixedDescription
1440918311.2.0.3.4, 11.2.0.3.BP10, 11.2.0.4, 12.1.0.1ORA-600 [kjblpkeydrmqscchk:pkey] or similar / session hangs on "gc buffer busy acquire"
1418283511.2.0.3.BP14, 11.2.0.4, 12.1.0.1Process fails with ORA-600 [kjbrchkpkeywait:timeout]
1404341711.2.0.3.BP13, 11.2.0.4, 12.1.0.1ORA-600 [kjbrchkpkeywait:timeout] in RAC - superseded
  • '*' indicates that an alert exists for that issue.
  • '+' indicates a particularly notable issue / bug.
  • 'I' indicates an install issue / bug included for completeness.
  • 'P' indicates a port specific bug.
  • "OERI:xxxx" may be used as shorthand for ORA-600 [xxxx].


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:

Known Bugs
You can restrict the list below to issues likely to affect one of the following versions by clicking the relevant button:

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

相關文章