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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

865185

Very good article for a docker starter.

3387467

Me gustó, bastante clara la explicación para cualquier persona que quiera iniciarse en tecnología Docker.

1 - 2
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,657 views