Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedora 2

All posts relating to Oracle database administration.

Moderator: Tim...

Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedora 2

Postby Guest » Mon Nov 01, 2004 6:09 pm

First:
Perform installation procedure exactly as advised in [1].

Issue:-
# rpm -q libaio
libaio-0.3.99-3

We need libaio-0.3.96-3 to be installed instead of libaio-0.3.99-3
Find out two rpms dependent on libaio-0.3.99-3 and remove all three rpms
from the system.

Then install libaio-0.3.96-3:
# rpm -ivh libaio-0.3.96-3.i386.rpm libaio-devel-0.3.96-3.i386.rpm

Second:

Build "libaio-oracle" as root
Download libaio-oracle-0.3.0.tar.gz:
Source to libaio-oracle version 0.3.0
from
http://oss.oracle.com/projects/libaio-oracle/files

cd /tmp
gunzip libaio-oracle-0.3.0.tar.gz
tar xf libaio-oracle-0.3.0.tar
cd libaio-oracle-0.3.0
./configure
make install

Add to /etc/ld.so.conf

/lib
/usr/lib
/usr/local/lib

Restart Linux.
Run control test: lio_test.

Next:

su - oracle
Shutdown oracle
mv $ORACLE_HOME/rdbms/lib/skgaio.o $ORACLE_HOME/rdbms/lib/skgaio.orig
cp /tmp/libaio-oracle-0.3.0/libaio-oracle.o $ORACLE_HOME/rdbms/lib/skgaio.o
$make -f ins_rdbms.mk async_on
$make -f ins_rdbms.mk ioracle

Startup Oracle
Modify screen SPFILE of OEM concole
disk_asynch_io=true
filesystemio_options=asynch
Click "Apply"

Restart instance
Actually,file skgaio.o taking part in linking Oracle binaries,

$make -f ins_rdbms.mk async_on
$make -f ins_rdbms.mk ioracle

is now replaced by /tmp/libaio-oracle-0.3.0/libaio-oracle.o

References
1.http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_8.shtml
Guest
 

RE:Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedor

Postby Tim... » Mon Nov 01, 2004 6:09 pm

I'm assuming this is not a question but a statement of how you solved something.
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE:Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedor

Postby Guest » Mon Nov 01, 2004 6:09 pm

Sure,it is statement
Guest
 

RE:Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedor

Postby Tim... » Mon Nov 01, 2004 6:09 pm

OK ;-)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17937
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest