ORA-00600: 内部错误代码, 参数:[kcbgcur_9] 错误解析

Posted by PDSERVICE on Jun 01, 2016 In

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

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

ORA-600 [kcbgcur_9]错误的触发原理是当 buffer被以某种类型顺序pin住以便防止内部死锁时，发现当前buffer被以错误的类型顺序pinned或者同一class中有重复的buffer；也可能在更新只读表空间时与ORA-372错误一起发生。
该ORA-600 [kcbgcur_9]错误隶属于内核 buffer cache模块

这个ORA-600 [kcbgcur_9]错误一般有4个argument:

Arg [a] The Database Block Address (DBA)
Arg [b] The buffer class
Arg [c] Block class order mask
Arg [d] Block class checking mask

ORA-600 [kcbgcur_9]错误可能的影响是造成进程失败，但一般不会造成数据块的损坏

ORACLE SUPPORT对遇到该问题的主要建议是检查所有的系统硬件磁盘和内存，以便保证不是底层系统造成了该问题。

一些可能造成ORA-600 [kcbgcur_9]的BUG:

NB	Bug	Fixed	Description
	10061015	11.2.0.2.3, 11.2.0.2.BP08, 11.2.0.3, 12.1.0.1	ORA-600 [ktfbhget:clsviol_kcbgcur_9] can occur on transported in tablespace
	9407198	11.2.0.3, 12.1.0.1	“LOG ERRORS INTO” can cause ORA-600 [kcb***] or hang scenarios
	9133601	12.1.0.1	ORA-600 [kcbgcur_9] from MERGE into an IOT
	8459467	10.2.0.5, 11.2.0.1	ORA-600 [ktfbhget:clsviol_kcbgcur_9] attempting to ONLINE a tablespace
	7644703	10.2.0.5, 11.2.0.1	OERI[kcbgcur_9] on alter tablespace online
	6918892	11.2.0.1	ORA-600 [kcbgcur_9] from DML on sys.aud$
	4917666	10.2.0.3, 11.1.0.6	OERI[kcbgcur_9] from type constructor
	8778379	10.2.0.5	Fix event 10227 in 10.2 ORA-600[kcbgcur_3] or ORA-600[kcbgcur_9]
	3655948	10.1.0.5, 10.2.0.1	OERI:kcbgcur_9 during disconnect with distributed transaction
	3127116	9.2.0.5, 10.1.0.2	OERI:kcbgcur_9 during rollback of DML in ASSM segment
	2771042	9.2.0.6, 10.1.0.2	OERI[kcbgcur_9] when performing DML on an IOT with an FGA policy
	2747873	9.2.0.8, 10.1.0.2	DBMS_SPACE.UNUSED_SPACE may fail with OERI:kcbgcur_9
	2722809	9.2.0.4, 10.1.0.2	OERI:kcbgcur_9 on direct load into AUTO space managed segment
	2716406	10.1.0.2	OERI[kcbgcur_9] executing DBMS_SPACE.FREE_BLOCKS procedure on bitmapped segment
	2619895	9.2.0.8, 10.1.0.2	Dump / OERI:kcbgcur_9 using PLSQL in SET clause of MERGE .. UPDATE
	2392885	9.2.0.4, 10.1.0.2	Direct path load may fail with OERI:kcbgcur_9 / OERI:ktfduedel2
	2311214	9.0.1.4, 9.2.0.2, 10.1.0.2	OERI:KCBGCUR_9 possible for SQL against IOT
	1785175	9.2.0.2, 10.1.0.2	OERI:kcbgcur_9 from CLOB TO CHAR or BLOB TO RAW conversion
	4124059	9.2.0.8	OERI[kcbget_31] / similar KCB errors in single instance
	2202310	9.0.1.4, 9.2.0.1	OERI:KCBGCUR_9 possible from SMON dropping a rollback segment in locally managed tablespace
	2035267	9.0.1.3, 9.2.0.1	OERI:KCBGCUR_9 possible during TEMP space operations
	1804676	8.1.7.3, 9.0.1.3, 9.2.0.1	OERI:KCBGCUR_9 possible from ONLINE REBUILD INDEX with concurrent DML
	1397075	8.1.7.2, 9.0.1.0	OERI:KCBGCUR_9 from SMON during temp seg cleanup for segment in read only LOCALLY MANAGED TABLESPACE

You are here

ORA-00600: 内部错误代码, 参数:[kcbgcur_9] 错误解析