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 |
如果自己搞不定可以找ASKMACLEAN专业数据库修复团队成员帮您恢复!
Diagnosis: May occur with ORA-372 error when trying to update read-only tablespace or partition via direct load. Also reported with block corruption problems.The Buffer Class Order mask is a bitmap for each class of buffer.The values correspond to the classes of buffer which must NOT already be held when attempting to pin this buffer, including the current class.The Buffer Class Checking mask is a bitmap corresponding to the classes of buffers currently held by this process. This is what is being compared to the buffer class order mask. This internal error is identical to kcbget_33