| Oracle Instance Crashes Regularly [message #69269] |
Fri, 30 November 2001 21:04  |
Munish Jauhar
Messages: 3
Registered: November 2001
|
Junior Member |
|
|
Hi
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:ORACLEORADATALISCRCONTROL01.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.
Please help us out as to what the problem maybe.
Sincere Regards
Munish Jauhar
----------------------------------------------------------------------
|
|
|
|
| Re: Oracle Instance Crashes Regularly [message #69303 is a reply to message #69269] |
Thu, 06 December 2001 00:45  |
smk
Messages: 5
Registered: November 2001
|
Junior Member |
|
|
Hi, I think there is corruption on your hard disk where controlfile is located. If possible move the control file to other disk if available, or change the disk. Just try this out and let me know. If you need any help do let me know if i can help you.
Bye
Sanjay
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
