Home » RDBMS Server » Server Administration » DB Got Shutdown
DB Got Shutdown [message #271400] Mon, 01 October 2007 09:48 Go to next message
Messages: 294
Registered: February 2006
Senior Member

Our Dev Database went down and i have to restart, This is what i found in Log File,
Errors in file /u01/app/oracle/admin/neor1l1/bdump/neor1l1_dbw0_835.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 55 (block # 7538)
ORA-01110: data file 55: '/u01/app/oracle/oradata/neor1l1/misc_data_01.dbf'
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 5: I/O error
Additional information: -1
Additional information: 8192
DBW0: terminating instance due to error 1242

I have checked for the space on the box and as well as for this tablespace and status of Datafile all looks fine, This happened couple of times earlier and i have to restart the DB, what else do you people can cause this.

It's Oracle 9i Rel 2, on Solrais 5.9

Re: DB Got Shutdown [message #271405 is a reply to message #271400] Mon, 01 October 2007 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 65137
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check ulimit for file size.
You may have reached the max size for user oracle or OS.

Re: DB Got Shutdown [message #271456 is a reply to message #271400] Mon, 01 October 2007 12:49 Go to previous message
Messages: 4765
Registered: February 2005
Location: East Coast USA
Senior Member
Also, it could just be a plain media failure, in which case you have a problem as I see you are not in archive log mode. You will have to restore your latest backup or rebuild your DEV environment.

You might want to look in /var/adm/messages to see if there are any hard drive errors at the same time as the Oracle log file reports your error.
Previous Topic: 2 processors problem
Next Topic: database creation problem
Goto Forum:

Current Time: Thu Aug 17 04:58:38 CDT 2017

Total time taken to generate the page: 0.05209 seconds