Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-27072

Re: Error ORA-27072

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 15 Dec 2001 09:19:15 +0000
Message-ID: <3C1B1593.3A31@yahoo.com>


Gaby Spiessl wrote:
>
> 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

Typically you get this when Oracle cannot get exclusive access to the file in question. If there are things like backups, or other file accessing software running at the same time, then Oracle can complain...

Alternatively, the worst case scenario is a genuine hardware fault. Possibly try copying that control file to another location and seeing if the problem re-occurs.

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Sat Dec 15 2001 - 03:19:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US