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 1,170 Sep 24, 2004 6:07 AM
Axel.Thimm@atrpms.net feedback (rh9 kernel 2.4.20-35.9&AIO) dba477 0 1,206 Sep 21, 2004 1:10 AM
Kernel 2.4.20-35.9 does not support AIO on Red Hat Linux 9. dba477 0 2,134 Sep 16, 2004 6:22 AM
Quick upgrade Red Hat Linux 9 to get AIO working dba477 0 1,415 Sep 12, 2004 3:58 AM
filesystem_io=asynch should be filesystemio_options=asynch dba477 0 3,630 Sep 8, 2004 11:38 PM
Just to avoid any misunderstanding dba477 0 2,103 Sep 8, 2004 5:15 AM

You cannot post until you login.