Forum OpenACS Q&A: Oracle Service would stop every 3 days
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 ?
The permissions are set to full control to everyone so I guess that could not be the problem. Could it?