Vague error message

[THoey]

I ran a query to delete some old records from a database and got the following error:

delete from eventlog 
where trunc(datetime) = '08-MAY-01' and server = '1';

ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []

SQLWKS> select count(*) from eventlog 
     2> where trunc(datetime) = '08-MAY-01' and server = '1'
     3> 
COUNT(*)  
----------
    329022

I looked in Oracle 7.3.4 help and found the following:
This is a catchall internal error message for Oracle program exceptions. It indicates that a process has met a low-level, unexpected condition.

Various causes of this message include:
time-outs
file corruption
failed data checks in memory
hardware, memory, or I/O errors
incorrectly restored files

I ran several of these queries at the same time and this is the only one that failed. After the other queries failed, I ran it again and it failed with the same message. Sounds to me like file corruption. Is there any way to check if it is and how do I fix it? Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[Kenrae]

Have you applied last patches from Oracle? We had some internal errors and they fixed them.

 

[MikeJones]

Don't know if this is still a problem but you could stick a &quot;and rownum < X&quot; on the delete. Hopefully this would allow you to get rid of alot of the data and maybe narrow down exactly what the bad data is. As for the problem, ORA 600 error messages always send a shiver down my neck and have me running for the Phone and Oracle Support...

Mike.

 

[Swany]

Have you tried to validate the structure of the table?

&quot;alter table XXX validate structure;&quot;

I've had two ORA-600 running 8i on linux. The first was fixed by validating the structure of the table.

The second was fixed by taking the whole filesystem offline and running an fsck on it.