Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedora Core 2
Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedora Core 2
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) to turn Oracle AIO on
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
Now Red Hat FC2 kernel (2.6.5) will handle asynchronous I/O requests DBW0,DBW1 daemons.
Actually, to get the work done:-
We replaced file skgaio.o taking part in linking Oracle binaries
$make -f ins_rdbms.mk async_on
$make -f ins_rdbms.mk ioracle
by /tmp/libaio-oracle-0.3.0/libaio-oracle.o
References
1.http://www.idevelopment.info/data/Or.../LINUX_8.shtml