ORA-00600 [kdsgrp1]

2011年8月31日
下午收到短信通知，数据库发生ORA-600错误 [kdsgrp1]
检查告警日志文件错误信息如下：
Wed Aug 31 13:42:22 2011
Errors in file /oraclelog/ngcrm/udump/ngcrm2_ora_24329.trc:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], []

查看跟踪文件：
*** 2011-08-31 13:42:22.160
*** ACTION NAME:() 2011-08-31 13:42:22.158
*** MODULE NAME:(tcscrm1l1serve@crminf2 (TNS V1-V3)) 2011-08-31 13:42:22.158
*** SERVICE NAME:(ngcrm) 2011-08-31 13:42:22.158
*** SESSION ID:(2028.38527) 2011-08-31 13:42:22.158
row 9c47cf4c.2f continuation at
file# 625 block# 511820 slot 48 not found
以上信息说明文件编号为625的块号为511820的SLOT 48出问题了，查找不到数据。原因是由于系统中存在逻辑错误导致索引
有问题，从而引起某记录在表中找不到相应的数据。

查看出现错误的相关表：
select owner,segment_name,segment_type,tablespace_name from dba_extents where file_id=625 and block_id<=511820
and (block_id+blocks)>=511820;

OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME
----------- ---------------- ---------------- ------------------
UCR_CRM1 TF_B_TRADE_SVC TABLE PARTITION TBS_CRM_HDTRA4

查找到表名，继续在跟中文件中搜索"Plan Table"，查找哪个索引出的问题：
============
Plan Table
============
----------------------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 34 | |
| 1 | UNION-ALL | | | | | |
| 2 | FILTER | | | | | |
| 3 | PARTITION RANGE SINGLE | | 1 | 59 | 5 | 00:00:01 |
| 4 | TABLE ACCESS BY LOCAL INDEX ROWID | TF_F_USER_SVC | 1 | 59 | 5 | 00:00:01 |
| 5 | INDEX RANGE SCAN | PK_TF_F_USER_SVC | 1 | | 4 | 00:00:01 |
| 6 | NESTED LOOPS | | 1 | 62 | 8 | 00:00:01 |
| 7 | TABLE ACCESS BY INDEX ROWID | TF_B_TRADE | 1 | 22 | 5 | 00:00:01 |
| 8 | INDEX RANGE SCAN | IDX_TF_B_TRADE_USERID| 1 | | 3 | 00:00:01 |
| 9 | PARTITION RANGE SINGLE | | 1 | 40 | 3 | 00:00:01 |
| 10 | INDEX RANGE SCAN | PK_TF_B_TRADE_SVC | 1 | 40 | 3 | 00:00:01 |
| 11 | NESTED LOOPS ANTI | | 1 | 130 | 12 | 00:00:01 |
| 12 | NESTED LOOPS | | 1 | 90 | 9 | 00:00:01 |
| 13 | TABLE ACCESS BY INDEX ROWID | TF_B_TRADE | 1 | 22 | 5 | 00:00:01 |
| 14 | INDEX RANGE SCAN | IDX_TF_B_TRADE_USERID| 1 | | 3 | 00:00:01 |
| 15 | PARTITION RANGE SINGLE | | 1 | 68 | 4 | 00:00:01 |
| 16 | TABLE ACCESS BY LOCAL INDEX ROWID | TF_B_TRADE_SVC | 1 | 68 | 4 | 00:00:01 |
| 17 | INDEX RANGE SCAN | PK_TF_B_TRADE_SVC | 1 | | 3 | 00:00:01 |
| 18 | PARTITION RANGE SINGLE | | 1 | 40 | 3 | 00:00:01 |
| 19 | INDEX RANGE SCAN | PK_TF_B_TRADE_SVC | 1 | 40 | 3 | 00:00:01 |
| 20 | TABLE ACCESS BY LOCAL INDEX ROWID | TF_B_TRADE_SVC | 1 | 68 | 4 | 00:00:01 |
| 21 | NESTED LOOPS | | 1 | 90 | 9 | 00:00:01 |
| 22 | TABLE ACCESS BY INDEX ROWID | TF_B_TRADE | 1 | 22 | 5 | 00:00:01 |
| 23 | INDEX RANGE SCAN | IDX_TF_B_TRADE_USERID| 1 | | 3 | 00:00:01 |
| 24 | PARTITION RANGE SINGLE | | 1 | | 3 | 00:00:01 |
| 25 | INDEX RANGE SCAN | PK_TF_B_TRADE_SVC | 1 | | 3 | 00:00:01 |
----------------------------------------------------------------------+-----------------------------------+

访问表TF_B_TRADE_SVC的索引PK_TF_B_TRADE_SVC有误，删除该索引并重建，重建后这个错误就消失了。
也可以参考Oracle Support中相关的文章，文章标题是：Getting Ora-600 [kdsgrp1] On A Select [ID 429746.1]

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26121829/viewspace-1054619/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26121829/viewspace-1054619/