Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

ORA-01115: IO error reading block from file

Posted on 2001-06-05
6
Medium Priority
?
3,868 Views
Last Modified: 2008-03-17
Hello,
i am able to connect to oracle, and select * from tab works fine, but i am
not able to select any data from any of the tables, when ever i give a
select statement, i get this message. i am no DBA, can anyone please help
me.

SQLWKS> select * from iara_inc_aglog
ORA-01115: IO error reading block from file 3 (block # 99551)
ORA-01110: data file 3: 'D:\BILLDBSERVER\BILLDB\USR1BILL.ORA'
ORA-27070: skgfdisp: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 38) Reached end of file.

its on oracle 8.0.5 under Win NT.

thanks and regards,
Pinto.



0
Comment
Question by:pintoalex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 2

Accepted Solution

by:
RMZ earned 200 total points
ID: 6156289
hi
pls shutdown your database and restart it again
and connect using sql+ and try again
---rmz---
0
 
LVL 9

Expert Comment

by:dbalaski
ID: 6156425
Hi,

The errors are:
ORA-O1115, "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

ORA-27070, "skgfdisp: async read/write failed"
Cause: aioread/aiowrite system call returned error, additional information indicates starting block number of I/O
Action: check errno

Finally:
OSD-04006:   ReadFile() failure, unable to read from file
Cause:  Unexpected return from Windows NT system service ReadFile()
Action: Check OS error code and consult Windows NT documentation
--------------------------------------------------------

From what it looks like -- Oracle cannot access the file r/w  since there is an OS file lock on it.    
Did you recently perform an OS backup???

If so --  you need to configure the backup utility not to lock open files and shutdown the database during backups

Workaround for now:
Reboot the server -- this should clear the file locks and allow oracle to be restarted with r/w access to the file.

Hope this helps,
sincerely,
dBalaski



0
 
LVL 1

Expert Comment

by:ashokskumar
ID: 6157040
Hi,

Check the accessability of the file in the relative disk/drive/volume.

Backup may be in progress when you brought up the database and this would have turned the file into offline.  Check file status from v$datafile. If it is offline, you turn it online. You may get the message of file needs recovery.  

You can do the online recovery of the file alone when it is offline.(If database already done many log switches, database must be in archive log mode to do recovery).
And bring the file to online.

Ashok.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 1

Expert Comment

by:misho2000
ID: 6157484
Because your system is NT try to run chkdsk /i without /f option from dos prompt for disk where you place oracle files just to check for any errors. If you see any errors
ask your Oracle DBA to create another user tablespace but this one turn offline but do not drop because it blocks bad spot on disk.
HTH
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7035996
Please update and finalize this old, open question. Please:

1) Award points ... if you need Moderator assistance to split points, comment here with details please or advise us in Community Support with a zero point question and this question link.
2) Ask us to delete it if it has no value to you or others
3) Ask for a refund so that we can move it to our PAQ at zero points if it did not help you but may help others.

EXPERT INPUT WITH CLOSING RECOMMENDATIONS IS APPRECIATED IF ASKER DOES NOT RESPOND.

Thanks,

** Mindphaser - Community Support Moderator **

P.S.  Click your Member Profile, choose View Question History to go through all your open and locked questions to update them.
0
 
LVL 6

Expert Comment

by:Mindphaser
ID: 7043320
Force accepted

** Mindphaser - Community Support Moderator **
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question