I don't know...I've not enabled user quota, I've a lot of sapce free in all
the partitions, I don't have bad sectors, I don't have antivirus or
something that could lock some files...
"Mark Bole" <makbo_at_pacbell.net> wrote in message
news:TrG0d.18353$Ub7.15679_at_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 Tue Sep 14 2004 - 11:57:23 CDT
