Forum OpenACS Q&A: Oracle Service would stop every 3 days

Request notifications


One of our sites is on ACS 3 with Oracle as the backend. The Oracle (8.1.7) server is on a Windows NT machine.

The site has functioning splendidly for the last 6 months until last week. The Oracle service would just stop all of a sudden for no apparent reason. It has happened several times and we are unsure what's going on.

A look a the alert log yeilds the following notable errors :

ora-00206 : error writing (block 3, # blocks 1) of controlfile
ora-00202 : controlfile :
ora-27072 : skgfdisp: I/O error
osd-04008 : WriteFile() failure, unable to write to file
O/S Error: (OS 33) The process cannot access the file because another 
process has locked a portion of the file.
CKPT : terminating instance due to error 221

Looking that the error message, I had a hunch that it could be related to the disk failing or another program interfering with Oracle.

I am in the process of investigating. I am looking for backup software, antivirus software and probable bad sectors in the hard disk.

But I would like a second opinion. Has anybody here encountered this before ?

Posted by Sebastiano Pilla on
Also check that the OS user Oracle is running under has the proper permissions on the directory containg the controlfile.
Posted by Hamilton Chua on

The permissions are set to full control to everyone so I guess that could not be the problem. Could it?


Posted by Hamilton Chua on
Solved it - was definitely a backup script that was locking the control files.
Posted by Liz Fasanya on
I have a similar problem what exactly was happening in the back up scripts to cause this error and how did you fix it.