Solved

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

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

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 videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

739 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