| ORA-01115: IO error reading... [message #53992] |
Wed, 23 October 2002 04:47  |
Papi
Messages: 6
Registered: March 2002
|
Junior Member |
|
|
Hi,
When I send this SQL instruction : select count(*) from electeur ;
I have this error :
ORA-01115: IO error reading block from file 8 (block #15635)
ORA-01110: datafile 8 : '/u06/../elecni_data5_01.dbf'
ORA-27091: skgfqio: unable querie I/O
Linux Error:9: Bad file description
Additional information : 15603
I'm using Oracle 8i on a Linux Red Hat 7.1.
Can someone please help me to resolve this problem.
Thanks
|
|
|
|
|
|
| Re: ORA-01115: IO error reading... [message #54218 is a reply to message #53992] |
Tue, 05 November 2002 09:50  |
sharan alva
Messages: 57
Registered: November 1999
|
Member |
|
|
ORA-01115: IO error reading block from file 8 (block #15635)
ORA-01110: datafile 8 : '/u06/../elecni_data5_01.dbf'
ORA-27091: skgfqio: unable querie I/O
Linux Error:9: Bad file description
Additional information : 15603
The above error tells us that oracle is trying to read file 8, however it is unable to do so. Now the read and write to the o/s file is an o/s call from oracle so it looks like there is some problem with the file or the location of the file.
Check the file or the location from the o/s. Worst case you will need to restore the datafile from backup and recover it ( if you are in archivelog mode )
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
