Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle9 on Itanium-Linux

Rikki hinn Ogurlegi
Frequent Advisor

Oracle9 on Itanium-Linux

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.
3 REPLIES
Yogeeraj_1
Honored Contributor

Re: Oracle9 on Itanium-Linux

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Yogeeraj_1
Honored Contributor

Re: Oracle9 on Itanium-Linux

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Oracle9 on Itanium-Linux

Shalom,

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

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com