Re: OS 1453: Not enought space to complete request

From: Mark Bole <makbo_at_pacbell.net>
Date: Sat, 11 Sep 2004 17:18:43 GMT
Message-ID: <TrG0d.18353$Ub7.15679@newssvr27.news.prodigy.com>

Nicky wrote:

> 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.
>>>

[...]

> 


>>>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
[...]
>>
>>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

> 
> 
> 

Well, yes, to your question about it being better to use Linux not Windows!

A quick search of MS Knowledge base found what looks to be a similar error for SQL Server related to "OS 1453".

http://support.microsoft.com/default.aspx?scid=kb;en-us;274310

In this case it appears the "quota" is not a disk storage quota, but some memory-related (system resource) issue. Check your Windows events log, try tuning your pagefile size, or other non-Oracle items.

--Mark Bole Received on Sat Sep 11 2004 - 12:18:43 CDT