| Oracle Instance Crashes Regularly [message #99484] |
Fri, 30 November 2001 21:00  |
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 #99503 is a reply to message #99484] |
Thu, 13 December 2001 00:07  |
V.Srinivasa Rao Gupta
Messages: 2
Registered: December 2001
|
Junior Member |
|
|
May be the problem is due to bad sectors in the datafile or database files. Do one thing, first take the export dump of the existing database and drop the existing database and recreate it and import the dump into the newely created database.
Good Luck
VSRGupta.
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
