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

Applies to:

            Enterprise Linux – Version: 5

            Oracle Database 11gR2

           

Description:

             I have an update statement which modifies around 30000 records. Statement executed successfully on a single record, but when I execute to update all records it is going to fail with following error message:

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

Solution:

           

·         Open and view the alert log file when error occurred

·         Get the trace file name from alert log file and open it

·         Search the keyword “Plan Table” in trace file

·         Here you found details of the query causing problem

·         Identify the tables from above query and execute the following:

Analyze table <tab_name> validate structure cascade;

·         Identify all the indexes on the above tables and execute the following:

Analyze index <index_name> validate structure;

·         Here I found an index which fail to validate and return the below error:

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

·         Now I drop the index and recreate it.

·         After doing all the steps I resolved the above error.

Your comments, especially which will help us improve the functionality, will be greatly appreciatedJ