Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!news.mailgate.org!newscore.univie.ac.at!newsmi-eu.news.garr.it!NewsITBone-GARR!newsserver.cilea.it!not-for-mail From: "Nicky" Newsgroups: comp.databases.oracle.misc Subject: OS 1453: Not enought space to complete request Date: Thu, 9 Sep 2004 11:10:08 +0200 Organization: CILEA Lines: 82 Message-ID: NNTP-Posting-Host: 131.175.5.11 X-Trace: newsserver.cilea.it 1094720943 30778 131.175.5.11 (9 Sep 2004 09:09:03 GMT) X-Complaints-To: news@cilea.it NNTP-Posting-Date: 9 Sep 2004 09:09:03 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:112531 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