Q

Input/output errors

I have the following error:

ERROR at line 1:
ORA-01115: IO error reading block from file 2 (block # 2772)
ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2771

I have the following error:

ERROR at line 1:
ORA-01115: IO error reading block from file 2 (block # 2772)
ORA-01110: data file 2: '/home5/oracle/oradata/lrec_ts_files/lrec.dbf'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
Linux Error: 5: Input/output error
Additional information: 2771
It looks to me like the database is having problems performing I/O on the file '/home5/oracle/oradata/lrec_ts_files/lrec.dbf.' There are a few causes for this.

  1. The OS cannot perform I/O on the disk volume. Try the following:

       cd /home5/oracle/oradata/lrec_ts_files
       ls -l
    

    If you can do a directory listing, then the OS can see this volume just fine. If not, then you will have to resolve the OS issue as this is not a database problem.

  2. The datafile is bad for some reason. You can use the dbverify utility to see if the datafile is corrupt. If the datafile is bad, restore it from a backup.
  3. There is a bad spot on your disk. The dbverify utility should report this condition.
This was last published in August 2005

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close