Re: OS 1453: Not enought space to complete request

yes, I know it's a system error, but that error doesn't have sense because in that partition I have a lot of free space, no user quota enabled...i really don't know how

maybe it's better to use linux and not windows ?

thanks

<sybrandb_at_yahoo.com> wrote in message
news:a1d154f4.0409090747.36cba99e_at_posting.google.com...
> "Nicky" <fuffaspam_at_quipo.it> wrote in message
news:<chp6jf$u1q$1_at_newsserver.cilea.it>...
> > Hello !
> >
> > I've an installation of Oracle 9.2i on a new clean Windows 2000. After
some
> > hours of working (about 10.000 records inserted in tables), Oracle
crash. In
> > the alert_myinstance.log file I found that the error is:
> > OS 1453: Not enought space to complete request (I put a little extract
at
> > the end of this message).
> >
> > MyInstance database is on a partition with a lot of space free (10GB).
> > Initially I thought it was a problem of quota, but there are not quota
> > enabled on that machine.
> >
> > Looking to internet I found this help:
> > > If decrease parametr db_file_direct_io_count (example 64 -> 32) and
change
> > > parametr disk_async_io to "FALSE" then this error vanish.
> >
> > At the moment, I could not find the parameter db_file_direct_io_count.
But
> > the solution of changing only disk_async_io doesn't work. My oracle has
> > crashed again.
> >
> > Do you know some other possibility to solve my problem ?
> >
> > Thanks a lot.
> >
> > Nicky
> >
> >
> >
> >
> > alert_myinstance.log:
> >
> > Sat Sep 04 20:42:12 2004
> > Errors in file d:\oracle\admin\larcdb\bdump\larcdb_ckpt_2140.trc:
> > 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.
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL02.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.
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL01.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.
> >
> > Sat Sep 04 20:42:13 2004
> > Errors in file d:\oracle\admin\larcdb\bdump\larcdb_ckpt_2140.trc:
> > ORA-00221: error on write to controlfile
> > 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.
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL02.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.
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: 'O:\ORALARC\ORADATA\LARCDB\CONTROL01.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.
> >
> > Sat Sep 04 20:42:13 2004
> > CKPT: terminating instance due to error 221
> > Sat Sep 04 20:42:16 2004
> > Errors in file d:\oracle\admin\larcdb\bdump\larcdb_pmon_1996.trc:
> > ORA-00221: error on write to controlfile
>
>
> Your error is an *O/S* error, not an Oracle error.
> And db_file_direct_io_count is obsolete in 9i, IIRC. If it is
> obsolete, this is documented either in the release notes or in the
> admininistrators manual.
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Sep 09 2004 - 11:53:06 CDT