Home » RDBMS Server » Server Administration » ORA--00600 Error
ORA--00600 Error [message #53537] Thu, 26 September 2002 00:05 Go to next message
Rakesh Tripathi
Messages: 4
Registered: September 2002
Junior Member
Hello,

I run Oracle EE 8.0.5 on Sun (Solaris 7) system. My database abruptly goes down at times with the following message in the background dump file.

----------------------
*** 2002.09.24.14.37.44.000
*** SESSION ID:(2.1) 2002.09.24.14.37.44.000
ORA-01157: cannot identify data file 7 - file not found
ORA-01110: data file 7: '/u03/oradata/GSFC1/IMIS1GSFC1.dbf'
ORA-27041: unable to open file
SVR4 Error: 79: Value too large for defined data type
Additional information: 5
*** 2002.09.24.15.00.47.000
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[2844]], [[7]], [[1076752]], [[1076736]],
[[]], [[]], [[]], [[]]
---------------
Contrary to what the dump apparently suggests, the file IMIS1GSFC1.dbf is very much available, and when attempting to restart the instance, the database starts fine, with all datafiles available and all the tablespaces online.

Any ideas on the above behaviour ? Can anyone suggest what could be the reason for the above dump and abrupt shutdown of my database ?

Thanks,

Rakesh.
Re: ORA--00600 Error [message #53549 is a reply to message #53537] Thu, 26 September 2002 09:24 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
There is a bug that causes this. If your file is over 2GB then go to Metalink and download the patch (8.0.5.1) and install it.
Previous Topic: Re: ORA-12514: tns:LISTENER COULD NOT RESOLVE service_name GIVEN IN CONNECT DESCRIPTOR
Next Topic: Query takes too long
Goto Forum:
  


Current Time: Thu Sep 19 18:07:38 CDT 2024