ORA-00600: internal error code, arguments: [25027], [0], [0], [4], [1405199857], [],

Symptom :

ORA-00600,ORA-00600:[25027],[0],[0],[4] ,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 "DDPRS"

P2 "SQL code: 600"

P3 "SQL message: ORA-00600: internal error code, arguments: [25027], [0], [0],

[4], [1405199857], [], [], [], [], [], [], []"

P4 "SQL dbsl rc: 99"

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

For Eg:

Here issue is with table "DDPRS"

3. Finding out the table and related indexes:

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

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

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;

If analyze returns

 _{ORA-01499: table/index cross reference failure - see trace file}

5. Immediately after getting the ORA-01499 error ,execute the below  in the same SQL session:

 SQL> select tracefile from v$process where pid=userenv('pid');

6. To identify the index,open the trace file from point 5 and search for "index objn="

7.  Select object_name from dba_objects where object_id= XXX;  (object id from point 6)

8. Analyse the index and save the structure of the index :

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

SQL> set pagesize 0

SQL> set long 90000

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

9.  Drop the index with the issue:

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

10. Recreate the index with the saved structure in point 8 and analyze to check if any issues:

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

Hope this helps!!!

Abraham