Assemble all stuff together and improve style

Story: Asynchronous I/O for Oracle9iR2(9.2.0.5) on Red Hat Fedora Core 2Total Replies: 0
Author Content
dba477

Oct 09, 2004
10:56 AM EDT
First: Perform installation procedure exactly as advised in [1]. Check for libaio version has been installed:- # 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 (per Oracle Guide Lines two DBWRs should be enough). 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/Oracle/DBA_tips/Linux/LINUX_8.shtml

Posting in this forum is limited to members of the group: [ForumMods, SITEADMINS, MEMBERS.]

Becoming a member of LXer is easy and free. Join Us!