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

Comments

Post a Comment

Popular posts from this blog

How to Rebuild/Recreate Concurrent Manager

FRM-92101: Forms Server Not Starting Up

ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560