Problem solve
Get help with specific problems with your technologies, process and projects.
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.
- 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.
- 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.
- There is a bad spot on your disk. The dbverify utility should report this condition.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments