Ask the Expert

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

    Requires Free Membership to View

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 first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: