ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], []

Symptom :

ORA-00600,ORA-00600: [kdsgrp1], [], [], [], [],DBSQL_SQL_ERROR,CX_SY_OPEN_SQL_DB,

Index Corruption

Solution:

1. Check if you have any runtime errors in ST22:

For Eg : 

Parameters:
P1 "DD03L"
P2 "SQL code: 600"
P3 "SQL message: ORA-00600: internal error code, arguments: [kdsgrp1], [], [],
[], [], [], [], [], [], [], [], []"
P4 "SQL dbsl rc: 99"
P5 " "
P6 " "
P7 " "
P8 " "
P9 " "

2. Check if you can identify the table having the issue from the runtime error:

For Eg:

Here issue is with table "DD03L"

3. Finding out the table and related indexes:

select object_name,owner, object_type from dba_objects where object_name like 'DD03L%';

select INDEX_NAME,owner from dba_indexes where table_name='DD03L';

4. Analyzing the table and all the related index to check if any corruption:

ANALYZE TABLE <OWNER>."<TABLE_NAME>" VALIDATE STRUCTURE ONLINE;

ANALYZE INDEX <OWNER>."<INDEX_NAME>" VALIDATE STRUCTURE ONLINE;

Eg:

SQL> ANALYZE table SAPSR3."DD03L" VALIDATE STRUCTURE ONLINE;

Table analyzed  ->(This means table is successfully analyzed and no issues)

SQL> ANALYZE INDEX SAPSR3."DD03L~1" VALIDATE STRUCTURE ONLINE;

Index analyzed->(This means index is successfully analyzed and no issues)

SQL> ANALYZE INDEX SAPSR3."DD03L~2" VALIDATE STRUCTURE ONLINE;

Error at line 1:

ORA-00600,ORA-00600: [kdsgrp1], [], [], [], []

SQL>Select INDEX_NAME,owner from dba_indexes where table_name='DD03L';

Analyze all the indexes related to a table to check which all indexes are having the issue.

5.  Save the structure of all the indexes having the issues:

SQL> set pagesize 0

SQL> set long 90000

SQL> SELECT DBMS_METADATA.GET_DDL('INDEX','<INDEX_NAME>','<OWNER>') from dual;

6. Drop the index having the issue:

SQL> DROP INDEX "OWNER"."INDEX_NAME";

7. Recreate the index with the saved structure in point 5.

8. Analyze the index again to find if the issue is solved:

ANALYZE INDEX <OWNER>."<INDEX_NAME>" VALIDATE STRUCTURE ONLINE;

Refer SAP Note : 2373505 - 12c: Corrupt index with CREATE INDEX ONLINE

Hope this helps!!!

Abraham