Home » RDBMS Server » Networking and Gateways » Oracle Instance Crashes Regularly
Oracle Instance Crashes Regularly [message #66125] Fri, 30 November 2001 21:05 Go to next message
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 #66215 is a reply to message #66125] Fri, 01 February 2002 02:05 Go to previous messageGo to next message
andrew lament
Messages: 1
Registered: February 2002
Junior Member
is a backup agent trying to read /copy your control files???
Re: Oracle Instance Crashes Regularly [message #66873 is a reply to message #66125] Thu, 20 February 2003 23:25 Go to previous message
Susheel Gosavi
Messages: 1
Registered: February 2003
Junior Member
Dear Munish,
1)Please create new control file again.Refere dba admin guide for syntax and how to re-create new file from existing control file.
2) Please check the path of control file.

Regards
Susheel Gosavi
Previous Topic: Listener for a remote database
Next Topic: dblink between oracle 7.2 and oracle 9i
Goto Forum:
  


Current Time: Fri Mar 29 05:24:03 CDT 2024