Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Oracle SQL Select Statement 19 58
Out of Sequence numbers for today 25 47
oracle query help 18 78
compre toata in where clue oracle 4 44
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

760 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

20 Experts available now in Live!

Get 1:1 Help Now