This forum is currently locked. You can't register or post questions at this time. (read more)

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

All posts relating to Oracle database administration.

Moderator: Tim...

Guest

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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

Guest

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

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

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


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron