Solved

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

Posted on 2004-09-18
4
3,100 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
  • 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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

815 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now