Oracle9 on Itanium-Linux

[Rikki hinn Ogurlegi]

I have a Itanium server here running RHEL4 AS U5.
We plan to run Oracle9 on this machine. After installing Oracle9 and patching it to 9.2.0.8 I relinked Oracle to include support for Async IO (using libaio included in RHEL4).

Relinking seems to complete fine and "ldd oracle" does confirm that oracle is indeed using /usr/lib/libaio.sl.1"

When attempting to start the DB we get while running sqlplus "/ as sysdba":

oracleDUDE2: relocation error: oracleDUDE2: symbol io_queue_init, version LIBAIO_0.4 not defined in file libaio.so.1 with link time reference
ERROR:
ORA-12547: TNS:lost contact


Looks like the symbol version in libaio are wrong for Oracle 9.2.0.8

[root@rek-oradb-t01 ~]# rpm -qa | grep libaio
libaio-devel-0.3.105-2
libaio-0.3.105-2

In $ORACLE_HOME/lib/stubs we have stub versions of the libraries:

[root@rek-oradb-t01 stubs]# ll libaio*
-r-xr-xr-x 1 oracle oinstall 8242 júl 4 2006 libaio-2.2.4-stub.so
-r-xr-xr-x 1 oracle oinstall 8242 júl 4 2006 libaio.so
-r-xr-xr-x 1 oracle oinstall 8242 júl 4 2006 libaio.so.1

I renamed then and put in their place symbolic links to the real shared libraries:

[root@rek-oradb-t01 stubs]# mv libaio.so libaio.so.not
[root@rek-oradb-t01 stubs]# mv libaio.so.1 libaio.so.1.not
[root@rek-oradb-t01 stubs]# ln -s /usr/lib/libaio.so .
[root@rek-oradb-t01 stubs]# ln -s /usr/lib/libaio.so.1 .

Now Oracle relinks and runs propperly, but performs like a dog :( If I was to guess, i'd say that Async IO was indeed not working.

SQL> show parameter filesystemio_options

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
filesystemio_options string SETALL


SQL> show parameter async

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
disk_asynch_io boolean TRUE
tape_asynch_io boolean TRUE


Can anyone tell me what is the right way to fix this aio problem of mine ?
Also, are there any Oracle best practices documents out there for Linux on IA64 ?

Thanks in advance.

[Yogeeraj_1]

hi,

There is one document on metalink with subject: Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64 Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 10.2)

Doc ID: Note:169706.1

You may also wish to again go through Note 334563.1 Pre-Install checks for 10gR2 RDBMS (10.2.x) - HPUX PA-RISC and Itanium Platforms.

good luck
kind regards
yogeeraj

[Yogeeraj_1]

hi again,

about the second note, please instead refer to Note 283749.1 Pre-install Checks for 10gR1 RDBMS (10.1.x) - Linux Itanium 64

kind regards
yogeeraj

[Steven E. Protter]

Shalom,

I'd take a look at the install logs for Oracle. I suspect a pre-requisite has not been met.

SEP