Solved

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

Posted on 2004-09-18
4
3,179 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:jamshe
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 7

Accepted Solution

by:
BobMc earned 20 total points
ID: 12091955
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
 
LVL 7

Expert Comment

by:BobMc
ID: 12091986
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question