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

 This error normally occur  because of the INDEX or table structure is in consistent mode.

Analyze the index structure and tables.
If index structure is failed in analyze , drop the index and recreate the index.

please ensure it is shadow instance or Default instance.

Step:0

SQL> select INDEX_NAME from dba_indexes where table_name=’DD03L~’;
INDEX_NAME
——————————————————————————–
DD03L^0
DD03L^7
DD03L^6
DD03L^2
DD03L^3
DD03L^4
DD03L^5
DD03L^1

SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.

ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [],
[], [], [], [], []

Step:1
SQL> set pagesize 0

SQL> set long 90000

SQL> SELECT DBMS_METADATA.GET_DDL(‘INDEX’,’DD03L^1′,’SAPSR3′) from dual;

 CREATE  INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;

Step:2

SQL> DROP INDEX “SAPSR3”.”DD03L^1″;

     Index dropped
Step:3

SQL> CREATE  INDEX “SAPSR3”.”DD03L^1″ ON “SAPSR3″.”DD03L~” (“TABNAME”, “AS4LOCAL”, “POSITION”, “AS4VERS”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 299630592 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE “PSAPSR3740”;

  Index created.

Step:4

SQL> ANALYZE INDEX sapsr3.”DD03L^1″ VALIDATE STRUCTURE ONLINE;
Index analyzed.

Related posts

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB

ORA-16086: Redo data cannot be written to the standby redo log