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

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

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:

Fixed:

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

  欢迎关注我的微信公众号"IT小Chen"，共同学习，共同成长！！！