OS 1453: Not enought space to complete request

From: Nicky <fuffaspam_at_quipo.it>
Date: Thu, 9 Sep 2004 11:10:08 +0200
Message-ID: <chp6jf$u1q$1@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 Received on Thu Sep 09 2004 - 04:10:08 CDT