Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-27072
Hi Gaby,
in NT environments files are locked by the first process which opens the
file.
In your case, another process opened your controlfile. This can be an editor
or (hopefully not!) another oracle database process (may be from "hanging"
database and no proper restart?).
Please check your process list using the taskmanager for processes looking a
bit suspicious...
To get it shure, that no other process uses your controlfile, reboot your system and start Oracle again.
regards
Hartmut
"Gaby Spiessl" <gspiessl_at_gmx.at> schrieb im Newsbeitrag
news:9vcdi202g6i_at_enews4.newsguy.com...
> I have the following Oracle-Error:
> Oracle 8.1.7 on Win2000 Server
>
> *** 2001-12-13 22:41:02.477
> *** SESSION ID:(4.1) 2001-12-13 22:41:02.446
> ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> ORA-00202: controlfile: 'E:\ORACLE\FIBU\CONTROL\CONTROL02.CTL'
> ORA-27072: skgfdisp: I/O error
> OSD-04008: WriteFile() failure, unable to write to file
> O/S-Error: (OS 33) Der Prozess kann nicht auf die Datei zugreifen, da ein
> anderer Prozess einen Teil der Datei gesperrt hat.
> error 221 detected in background process
>
> At 22.30 an automatic Export is started.
> I have enough Disk Space and nobody is working at this time.
>
> --
> Gaby Spiessl
> gspiessl_at_gmx.at
>
>
Received on Fri Dec 14 2001 - 03:38:43 CST