Home
The Toolkit for Online Communities
17622 Community Members, 0 members online, 3127 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : Oracle Service would stop every 3 days

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

Icon of envelope Request notifications

Hello,

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 ?

Collapse
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.
Collapse
Posted by Hamilton Chua on
Thanks,

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

Regards,

Collapse
Posted by Hamilton Chua on
Solved it - was definitely a backup script that was locking the control files.
Collapse
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.

Ta