Re: ORA-01115 on Oracle 8.1.7 on Win2K

Nicolas Bronke wrote:
>
> Suddenly, I got following errors
>
> FEHLER in Zeile 1:
> ORA-01115: EA-Fehler beim Lesen von Block aus Datei 3 (Block Nr. 923)
> ORA-01110: Datendatei 3: 'C:\ORACLE\ORADATA\SW\DATEN.DBF'
> ORA-27091: skgfqio: E/A kann nicht in Warteschlange gestellt werden
> OSD-04006: ReadFile()-Fehler, Lesen aus Datei nicht möglich
> O/S-Error: (OS 1117) Die Anforderung konnte wegen eines E/A-Gerätefehlers
> nicht
> ausgeführt werden.
>
> Does that mean a truly disk error or is there a problem with the databas?
>
> The database is Oracle 8.1.7 with patch 8.1.7.1.1 on Win2K
>
> Thanks for recommendations.
>
> Nicolas

Hello Nicolas,
please check your alert file and take a look at the error Manual.

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76999/toc.htm

Got the following info with oerr:
01115, 00000, "IO error reading block from file %s (block # %s)" // *Cause: Device on which the file resides is probably offline // *Action: Restore access to the device [test62_at_dog exp_imp]$ oerr ORA 27091
27091, 00000, "skgfqio: unable to queue I/O" // *Cause: read/write/readv/writev system call returned error, additional
// information indicates starting block number of I/O // *Action: check errno

Regards
Manuela Mueller Received on Tue Oct 16 2001 - 10:34:13 CDT