ORA-00600: 內部錯誤程式碼, 引數: [kcbchg1_14]

ORA-00600: 內部錯誤程式碼, 引數: [kcbchg1_14]

資料庫版本：Oracle 10.2.0.5.0

資料庫伺服器作業系統：Windows server 2008

問題現象：業務人員在前臺執行某些計算操作時，ORA-00600: 內部錯誤程式碼, 引數: [kcbchg1_14] ], [], [], [], [], [], [], []；

解決方案：檢視alert警告日誌，查詢對應的trace檔案;

。。。。。。

*** CLIENT ID:(ncMem01#WebContainer : 3) 2016-03-03 09:02:56.796

*** SESSION ID:(1075.1160) 2016-03-03 09:02:56.796

BH (00000003D8F89438) file#: 8 rdba: 0x0205ef69 (8/388969) class: 1 ba: 00000003D8244000

發現：問題出現在8號資料檔案，388969塊對應的物件上；

。。。。。。

Block header dump:  0x0205ef69

 Object id on Block? Y

 seg/obj: 0x2c7d3  csc: 0x00.14d8d008  itc: 3  flg: E  typ: 2 - INDEX

     brn: 1  bdba: 0x205ef59 ver: 0x01 opc: 0

     inc: 0  exflg: 0

發現：此物件型別為INDEX;

。。。。。。

找到觸發此bug的sql語句如下：

Current SQL statement for this session:

INSERT INTO TAB_1(COL_1,COL_2,COL_3) VALUES(:1,:2,:3);

根據MOS檢視，和 Bug 8255717比較匹配，但沒有提供解決方案；

解決方案：

找到具體出現問題的索引物件，進行刪除重建索引，或者升級資料庫，跳過此BUG；

一：通過file_id和block_id查詢具體索引物件

select segment_name,owner,tablespace_name from dba_extents where 388969 between BLOCK_ID and BLOCK_ID+BLOCKS-1 and FILE_ID=8;

select index_name,table_name,column_name from user_ind_columns where index_name='INDEX_NAME';

二：刪除重建該索引

select dbms_metadata.get_ddl('INDEX','INDEX_NAME','USER_NAME') from dual;

drop index ......;

create index ......;

其中MOS中查詢有關ORA-00600[kcbchg1_14]問題相關資訊；

 

ORA-600/ORA-7445/ORA-700 Error Look-up Tool (文件 ID 153788.1)

ORA-600 [kcbchg1_14] (文件 ID 1267223.1)

In this Document

Purpose

Scope

Details

Oracle Database - Enterprise Edition - Version 8.1.7.0 and later
Information in this document applies to any platform.

Note: For additional ORA-600 related information please read Document 1092832.1

  This article represents a partially published OERI note.

  It has been published because the ORA-600 error has been 
  reported in at least one documented bug and/or confirmed Support Related Article.

  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:
  ORA-600 [kcbchg1_14] [a] [b] [c] [d] [e]

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

NB	Bug	Fixed	Description
	8255717	11.2.0.1	ORA-600 [kcbchg1_14] can occur

 

 

Bug 8255717 - ORA-600 [kcbchg1_14] can occur (文件 ID 8255717.8)

Bug 8255717  ORA-600 [kcbchg1_14] can occur

 This note gives a brief overview bug 8255717. 
 The content was last updated on: 16-NOV-2010
 Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions BELOW 11.2
Versions confirmed as being affected	11.1.0.7
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in		11.2.0.1 (Base Release)
Symptoms:		Related To:
Internal Error May Occur (ORA-600) ORA-600 [kcbchg1_14]		(None Specified)

Description

ORA-600[kcbchg1_14] can occur.

References

Bug:8255717 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article

 

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