Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Autorecovery when oracle crash

Re: Autorecovery when oracle crash

From: Nicky <fuffaspam_at_quipo.it>
Date: Fri, 17 Sep 2004 13:31:06 +0200
Message-ID: <ciehrr$vs4$1@newsserver.cilea.it>


I know that Oracle tell me it's a disk problem. But there are not quota enabled, a lot of disk space free, no bad sector, no wrong privileges on these files, nothing of nothing. Oracle works for 5-6 hours and then crash without a justification.

"Hans Wijte" <Hans.Wijte_at_mail.ing.nl> wrote in message news:2dec747a.0409160607.3cd03bdf_at_posting.google.com...
> "Nicky" <fuffaspam_at_quipo.it> wrote in message
news:<ci77fb$3a9$1_at_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.
> >
>
> The above error suggests that you have a disk problem; somehow, Oracle
> can not write to the controlfile located on that disk, either because
> the disk has gone down the drain, or because the authorizations for
> the controlfile are
> such that Oracle can not write to it, etc.
> I suggest you fix this problem before trying to install another OS
>
> Hans Wijte
Received on Fri Sep 17 2004 - 06:31:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US