Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!syros.belnet.be!news.belnet.be!newsmi-eu.news.garr.it!NewsITBone-GARR!newsserver.cilea.it!not-for-mail From: "Nicky" Newsgroups: comp.databases.oracle.misc Subject: Re: OS 1453: Not enought space to complete request Date: Thu, 9 Sep 2004 18:53:06 +0200 Organization: CILEA Lines: 113 Message-ID: References: NNTP-Posting-Host: 131.175.5.11 X-Trace: newsserver.cilea.it 1094748721 3290 131.175.5.11 (9 Sep 2004 16:52:01 GMT) X-Complaints-To: news@cilea.it NNTP-Posting-Date: 9 Sep 2004 16:52:01 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:112550 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 wrote in message news:a1d154f4.0409090747.36cba99e@posting.google.com... > "Nicky" wrote in message news:... > > 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