ORA-00600: 内部错误代码, 参数: [kcbchg1_14]

最新推荐文章于 2023-05-10 10:28:31 发布

ckth47350

最新推荐文章于 2023-05-10 10:28:31 发布

阅读量298

点赞数

文章标签：数据库操作系统

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

APPLIES TO:

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

PURPOSE

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.

SCOPE

ERROR:
ORA-600 [kcbchg1_14] [a] [b] [c] [d] [e]

DETAILS

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.

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.