Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01115: IO error reading block

56515Dec 14 2005 — edited Dec 15 2005
Hi,

We have installed a Oracle Database 10g R2 RAC.
The env are as follows:

OS: SELS 9 64bits
Hardware: two IBM 366 with 4CPUs
File System: OCFS2

oracle@rac1:~> ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) 8589934590
max memory size (kbytes, -m) unlimited
open files (-n) 999999
pipe size (512 bytes, -p) 8
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 999999999
virtual memory (kbytes, -v) unlimited

It ran quite well except a daily job.
Every night, when the job runs, we would get the errors randomly anywhere in our store procedure.
The errors are like these.

ORA-01115: IO error reading block from file 4 (block # 8713)
ORA-01110: data file 4: '/opt/oracle/oradata/dvpc/users01.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Linux-x86_64 Error: 4: Interrupted system call
Additional information: 3
Additional information: 8699
Additional information: 49152

ORA-01115: IO error reading block from file 20 (block # 154540)
ORA-01110: data file 20: '/opt/oracle/oradata/dvpc/dvpc2nd_indx02.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 3
Additional information: 154531
Additional information: 8192


Any suggestions would be appreciated.
Jimmy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2006
Added on Dec 14 2005
3 comments
1,699 views