ORA-00600: internal error code, arguments: [12700], [3315], [42060247], [10], [], [], [], []

Problem

Alert log shows the following error

Tue Nov 14 12:13:39 2006

Errors in file /oracle/app/oracle/admin/DSOFT/udump/ora_15410.trc:

ORA-00600: internal error code, arguments: [12700], [3315], [42060247], [10], [], [], [], []

Tue Nov 14 12:38:24 2006

  Solution

Open the trace file reported above

$ vi /oracle/app/oracle/admin/DSOFT/udump/ora_15410.trc

/oracle/app/oracle/admin/DSOFT/udump/ora_15410.trc

Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production

With the Partitioning and Parallel Server options

JServer Release 8.1.7.0.0 - Production

ORACLE_HOME = /oracle/app/oracle/product/8.1.7

System name:    OSF1

Node name:      NGP1

Release:        V4.0

Version:        1229

Machine:        alpha

Instance name: DS1

Redo thread mounted by this instance: 1

Oracle process number: 144

Unix process pid: 15410, image: oracle@NGP1 (TNS V1-V3)

*** SESSION ID:(81.2020) 2006-11-14 12:13:39.264

*** 2006-11-14 12:13:39.264

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [12700], [3315], [42060247], [10], [], [], [], []

Current SQL statement for this session:

SELECT COUNT(*) FROM ADVICE_NOTE WHERE WORK_ORDER_NO LIKE 'KHML%' AND

REMARKS = 'THIS ADVICE NOTE IS GENERATED THROUGH BULK ADVICE NOTE GENERATION'

----- Call Stack Trace -----

*** 2006-11-14 12:13:51.322

calling              call     entry                argument values in hex

location             type     point                (? means dubious value)

ALTER TABLE ADVICE_NOTE MOVE TABLESPACE <tablespacename>;

Table altered.

select index_name from dba_indexes where table_name='ADVICE_NOTE';

Then Rebuild all the indexes.