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

Srini Chavali-Oracle
CentOS is not a supported distro for any Oracle database installs - so things may or may not work as expected.

Is there a reason you cannot use a supported OS ? Pl also use the latest version (11gR2) of the database, as older versions are desupported.

10gR1 - http://docs.oracle.com/html/B10811_01/ch2.htm#i1011082

11gR2 - http://docs.oracle.com/cd/E11882_01/install.112/e24321/pre_install.htm#CIHFICFD

HTH
Srini
Andes
Hi

Thanks for ur reply, i use this Oracle version because our apps can't run in above 10g R1 of Oracle version. and this CentOS is free.
AFAIK CentOS is almost the same with RHEL, isn't it ? so it should be use same rpm.
in my case i think, this because of our CentOS version is higher that pre-req of Oracle 10gR1 version.
and i'd like to know is there any workarround to solve this problem ? i've tried to force install some rpms that needed by oracle installations.

Regards,
Nikolay Ivankin
Andes wrote:
Hi

Thanks for ur reply, i use this Oracle version because our apps can't run in above 10g R1 of Oracle version. and this CentOS is free.
Oracle Enterprise Linux also is free, use it instead of CentOS.
Helios-GunesEROL
Hi;

As mention here Centos is not certified platform. You can use OEL linux which is certified wiht Oracle Db and also free. Its avaliable at e-delivery site:

edelivery.oracle.com

PS:Please dont forget to change thread status to answered if it possible when u belive your thread has been answered, it pretend to lose time of other forums user while they are searching open question which is not answered,thanks for understanding

Regard
Helios
Andes
Hi,

I have already tried to install in RHEL paltform, but still the error occured. same error which is related to 'relink'
I put some of installAction log :
End output from spawned process.
----------------------------------
Exception thrown from action: make
Exception Name: MakefileException
Exception String: Error in invoking target 'relink' of makefile '/app2/oracle/product/10.2/db_1/precomp/lib/ins_precomp.mk'. See '/app/oraInventory/logs/installActions2012-08-27_01-55-19PM.log' for details.

I'm sorry that I can't update this thread being answered, as i have still problem and i need suggestion. As i'm now installing on OEL, let's see if the error still occured.

Regards,

Edited by: Andes on Aug 27, 2012 12:15 AM
Azar
Can you check prerequistes of oracle install ?

http://kamranagayev.com/2009/05/01/step-by-step-installing-oracle-database-10g-release-2-on-linux-centos-and-automate-the-installation-using-linux-shell-script/
Andes
Hi,

I'm trying to install Oracle 10g R1, on RHEL 5.8, yes for prerequisites there are 3 rpm that need to install and these are old version rpms. i have tried forcefully installing the rpm but still failed. so what should id ?
I read on oracle doc, that recomended OS version for 10g R1 is RHEL 3.x, is it true that we can't install oracle 10g R1 on RHEL 5.8 ?

Regards,
Srini Chavali-Oracle
As asked earlier, what is the reason for trying to install a desupported version of the database (10gR1) ? 10gR1 is not certified with RHEL 5.x

HTH
Srini
Andes
Hi,

I'd like to upgrade my prod database 10g R1 32bit into 10g R2 64bit, but before that we need to have development test before running on live upgrade. Thanks.

Regards,
sb92075
Andes wrote:
Hi,

I'd like to upgrade my prod database 10g R1 32bit into 10g R2 64bit, but before that we need to have development test before running on live upgrade. Thanks.

Regards,
why replace one unsupported version for another unsupported version?
V10 Oracle RDBMS is no longer being supported!
Andes
for ur curriousity, because the application only running on 10g db so i've been told by app vendor , don't ask me why this such thing happens :)

so for my above problem, is there any solution that can be shared ?

Thanks,
Srini Chavali-Oracle
What is your current OS ? You will need to clone the current 10gR1 binaries from your production system to an identical test system using OUI

Cloning An Existing Oracle10g Release 1 (10.1.0.x) RDBMS Installation Using OUI [ID 559301.1]

Then clone the database, perform a database upgrade and then test

HTH
Srini
1 - 12
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,662 views