Re: OS 1453: Not enought space to complete request

"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 - 10:47:32 CDT