Re: Autorecovery when oracle crash

From: Nicky <fuffaspam_at_quipo.it>
Date: Tue, 14 Sep 2004 18:50:50 +0200
Message-ID: <ci77fb$3a9$1@newsserver.cilea.it>

You're right !

> Oracle version : 9.2i enterprise
> Operating system verison ... win2k
> Error message ... taken from alertdb.log:

        ORA-00206: error in writing (block 3, # blocks 1) of controlfile
        ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL03.CTL'
        ORA-27072: skgfdisp: I/O error
        OSD-04008: WriteFile() non riuscito, impossibile scrivere sul file
        O/S-Error: (OS 1453) Disponibilità insufficiente per completare il

servizio richiesto.

I can't understand why oracle crash every 5 hours of work. I use normal SQL query, a lot of insert...but afeter only 50.000 record inserted oracle crash and I get the previous error in the log file. I have a lot of GB free in all the partitions of the machine, I don't have quota enable, the partition have not bad sectors, there isn't a software (such as an antivirus) that lock some files, I really can't understand...so I think that the solutions are:

- use linux ?
- use another DB server ?
- autorestart oracle whenever it crash and enforce my application in order

to support oracle crashes.

I really don't know how go on

thanks
bye

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1094784690.781482_at_yasure...
> Nicky wrote:
>
> > Hello
> >
> > Sometimes, my oracle server crash due to some problems I can't resolve
at
> > the moment.
> > The only possibiliy I have to restart the oracle server, is restart the
> > machine. (the commadn line tool: "LSNRCTL Start" doesn't work).
> >
> > Do you know if there is an automatic tools that understand when oracle
crash
> > and that can restart it ? which are the services I can automatically
restart
> > using windows
> > 2000/XP built-in service recovery functions ?
> >
> > Thanks you very much
> > Nicky
>
> Oracle version ... apparently not important.
> Operating system verison ... apparently not important.
> Error message ... apparently not important.
> Getting help ... apparently not important either.
>
> If you server is crashing ... fix the problem. Or is the integrity of
> your system also not important?
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
Received on Tue Sep 14 2004 - 11:50:50 CDT