ORA-00600: internal error code, arguments: [25012], [12], [0], [], [], [], [], []

alert log file is generate this error ORA-00600: internal error code, arguments: [25012], [12], [0], [], [], [], [], [] and generated a trace file rydpark_ora_27985.trc
trace file contains following
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
ORACLE_HOME = /home/oracle/oracle9i
System name:      Linux
Node name:      RYDPARKDB
Release:      2.4.9-e.3smp
Version:      #1 SMP Fri May 3 16:48:54 EDT 2002
Machine:      i686
Instance name: RYDPARK
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 27985, image: oracle@RYDPARKDB (TNS V1-V3)

*** SESSION ID:(15.13502) 2004-09-17 23:11:16.591
*** 2004-09-17 23:11:16.591
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [25012], [12], [0], [], [], [], [], []
Current SQL statement for this session:
SELECT *   FROM PARKING_TRANS  WHERE PTRNS_BUS_UNIT = :b1  AND PTRNS_TRANS_NO =  (SELECT MAX(PTRNS_TRANS_NO)   FROM PARKING_TRANS  WHERE PTRNS_ENTRY_UNIT = :b2 )  AND NVL(PTRNS_CAR_REG_PFX,'NULL') = NVL(:b3,'NULL')  AND PTRNS_CAR_REG_NO = :b4
jamsheAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BobMcConnect With a Mentor Commented:
Heres a note from Oracle, if this isnt the exact bug you are hitting, the solution is invariably the same - patch up to latest release.

PURPOSE
-------
 
To fix error ORA-00600 [25012], while performing select or insert on a table.
 
 
SCOPE & APPLICATION
-------------------
 
All users.
 
 
ORA-00600 [25012], while performing select or insert on a table
---------------------------------------------------------------
 
Description:
------------  
You are always getting error, ORA-00600 [25012], while doing select or
insert on a table.  
The table has indexes created with PARALLEL clause.
 
Cause:
------
Bug 2531519
 
Loading data into a bitmap managed table using parallel direct-path insert may  
fail with ORA-600 [25012] errors.
 
Solution:
---------
Recreate the indexes with NOPARALLEL clause.
The bug is fixed in 9203 release. One off patches are available on 9202 and 9.0.1.X
releases.
 
RELATED DOCUMENTS
-----------------
Bug 2531519

0
 
BobMcCommented:
Theres actually a lot of causes - almost all seem to revolve around dodgy indexes where the rowid specified in the index doesnt resolve to a known datafile.

try analyze table parking_trans validate structure cascade;
or rebuild any indexes on this table

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.