We have installed Oracle 8.1.7 on a Windows2000 server, and everything was working smoothly for a couple of months, however in the past couple of weeks the Oracle instance has been stopping regularly and the frequency of the stoppages is also increasing. Here is what the trace file says:
*** 2001-12-01 00:09:08.796
*** SESSION ID:(4.1) 2001-12-01 00:09:08.734
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\ORACLE\ORADATA\LISCR\CONTROL01.CTL'
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.
*** 2001-12-01 00:09:18.796
error 221 detected in background process
I looked at the Windows2000 server event log and noticed that the OracleOraHome81Agent was shutting down so I went ahead and changed the services property, so that is it stopped/crashed again it would automatically be re-started....however the Oracle instance error still persisted. I also looked at the event log, to see if any other services that may cause the rror maybe running at that point in time, but no luck. Regarding the free space issue, our database does not have a large amount of data and we have around 6GB of free HDD space, so that does not seem to be the problem either.