Asynchronous I/O implementation for Red Hat Linux 9 .Relinking Oracle9iR2 to utilize AIO

Posted by dba477 on Sep 8, 2004 4:33 AM EDT
LXer; By Boris Derzhavets 		Mail this story
Print this story

Asynchronous I/O doesn't go along with Red Hat Linux 9 automatically. It's affecting performance of any database server working in Red Hat Linux environment , which is not RHEL Advanced Server or Entry Level Server

Installation of new kernel with AIO support and patched version of libaio library 

1. rpm -i kernel-2.4.20-35.9.i686.rpm from http://atrpms.com
2. rpm -i libaio-0.3.93-4.src.rpm
3. cd /usr/src/redhat/SOURCES
4. gunzip libaio-0.3.93.tar.gz
5. tar xf libaio-0.3.93.tar -C /tmp
6. cd /tmp/libaio-0.3.93/src
7. Modify files:

 compat-0_1.c
 io_queue_init.c
 io_submit.c

as advised in [1],[2]
8.  cd /tmp
9.  tar cvf libaio-0.3.93.tar libaio-0.3.93
10. gzip libaio-0.3.93.tar
11. cp libaio-0.3.93.tar.gz /usr/src/redhat/SOURCES
12. rpmbuild -ba  /usr/src/redhat/SPECS/libaio.spec
13. cd /usr/src/redhat/RPMS/i386
14. rpm -i libaio-0.3.93-4.i386.rpm
15.Check for file /usr/lib/libaio.so.1 to appear
16. cd /lib
17. ln -s /usr/lib/libaio.so.1 libaio.so

Relinking Oracle to utilize AIO for filesystems

Shutdown Oracle:- 

1. cd $ORACLE_HOME/rdbms/lib
2. make -f ins_rdbms.mk async_on
3. make -f ins_rdbms.mk ioracle
4. cd $ORACLE_HOME/dbs

Add to init.ora files of instances currently installed on box:- 

disk_asynch_io=true
filesystem_io=asynch

Startup Oracle

References
1.http://www.hyperic.net/support/tech-notes/oracle-setup.htm
2.http://developer.osdl.org/daniel/libaio/patch.libaio-0.3-93.fix

  Nav
» Read more about: Story Type: Tutorial

« Return to the newswire homepage

Subject Topic Starter Replies Views Last Post
Please view final results at the link bellow:- dba477 0 2,055 Sep 24, 2004 6:07 AM
Axel.Thimm@atrpms.net feedback (rh9 kernel 2.4.20-35.9&AIO) dba477 0 2,228 Sep 21, 2004 1:10 AM
Kernel 2.4.20-35.9 does not support AIO on Red Hat Linux 9. dba477 0 3,187 Sep 16, 2004 6:22 AM
Quick upgrade Red Hat Linux 9 to get AIO working dba477 0 2,594 Sep 12, 2004 3:58 AM
filesystem_io=asynch should be filesystemio_options=asynch dba477 0 4,966 Sep 8, 2004 11:38 PM
Just to avoid any misunderstanding dba477 0 3,187 Sep 8, 2004 5:15 AM

You cannot post until you login.