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

Collapse
1: Oracle Service would stop every 3 days
Posted by Hamilton Chua on 03/09/02 05:23 AM

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
2: Response to Oracle Service would stop every 3 days (response to 1)
Posted by Sebastiano Pilla on 03/11/02 10:08 AM
Also check that the OS user Oracle is running under has the proper permissions on the directory containg the controlfile.
Collapse
3: Response to Oracle Service would stop every 3 days (response to 1)
Posted by Hamilton Chua on 03/12/02 01:10 AM
Thanks,

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

Regards,

Collapse
4: Response to Oracle Service would stop every 3 days (response to 1)
Posted by Hamilton Chua on 03/13/02 03:37 AM
Solved it - was definitely a backup script that was locking the control files.
Collapse
5: Re: Response to Oracle Service would stop every 3 days (response to 4)
Posted by Liz Fasanya on 01/12/07 12:27 PM
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