Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

error's ORA 1568 - ORA 600

Posted on 1997-08-18
2
Medium Priority
?
874 Views
Last Modified: 2010-05-18
An error ORA-01578:ORACLE data block corrupted(file#16,block#24084)  often
appears (on a different file#) on a HASH CLUSTER, and is followed by an
error ORA-00600: internal error code,arguments:
[3339],[268452314],[234897882]

1) How can i do to detect this error before my application stop.
ORACLE preconizes the order : ANALYZE CLUSTER  VALIDATE
STRUCTURE CASCADE;

Have you got other solutions ?

2)How ca i analyze the parameters of the error ORA 600 ?

ORACLE tells me it's an hardware error, but EMC2 answers me there is no
hardware error's on the disk.

What do you think about it ?


Thank you very much for your help...


PS: Sorry for my poor english (I,m french. Mail pbuczek@magic.fr)
0
Comment
Question by:pbuczek
[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 Comments
 

Author Comment

by:pbuczek
ID: 1080424
Edited text of question
0
 
LVL 1

Accepted Solution

by:
rodo earned 400 total points
ID: 1080425
Yes, the ora-1578 may be caused by hardware error, but may
by an operating system or oracle bug also...
The main source of information are the arguments of the ora-600
to determine the real cause in your case. And... this is internal
information of Oracle Corp. that is not documented publically.
In these cases you have to ask them.

Ther is no general way of fore-seeing the aparition of this error. ANALYZE ... VALIDATE STRUCTURE is a way to recognize it.

If the corrupted segment is an index, then you can simply drop
and re-create it. If it is a table, there are some ways to
retrieve the information that resides on the remaining
non-corrupted datablocks.
e.g: there is an event (number 10231) for the initSID.ora file that causes the rdbms to ignore corrupted datablocks so you can
export the rest of the information. Obviously, this has some danger because looses some internal checking about the consistency of the datablocks, and must be set up under
Oracle Support supervision.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

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…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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…

610 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