Re: problem compiling c (pro*c) program - problem with oracle shared library

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sat, 28 May 2005 11:35:26 +0200
Message-ID: <d79e0m$n4e$02$1_at_news.t-online.com>


Daud schrieb:
> Sybrand Bakker wrote:
>

>>On 27 May 2005 23:43:35 -0700, "Daud" <daud11_at_hotmail.com> wrote:
>>
>>
>>>LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
>>>       export LD_LIBRARY_PATH
>>>
>>>       SHLIB_PATH=$ORACLE_HOME/lib32:/usr/lib:$ORACLE_HOME/rdbms/lib32
>>>       export SHLIB_PATH
>>
>>
>>Likely $ORACLE_HOME/lib has 64-bit libraries, and you can't definitely
>>point to *both* 64-bit libraries *and* 32-bit libraries.
>>Whether you need to set LD_LIBRARY_PATH or SHLIB_PATH is platform
>>dependent, and can be looked up in the documentation.
>>
>>
>>--
>>Sybrand Bakker, Senior Oracle DBA

>
>
> First I removed LD_LIBRARY_PATH and recompiled. NO luck.
> Then I added LD_LIBRARY_PATH and removed SHLIB_PATH. Recompiled and
> still no luck. Anything else I should check? What documentation are you
> talking about?
>
> regards
> Daud
>

As Sybrand pointed, you have most likely version mismatch. 1) LD_LIBRARY_PATH is for Solaris and Linux, you don't have to set this variable on HPUX ( of course, i have seen some commercial Makefiles that   seeks for LD_LIBRARY_PATH on HPUX, but IMHO , Oracle is aware of it. 2) I'm not sure about HPUX on Itanium 2, but assume , is 64 bit, you should see it with "uname -a"
3) Your Oracle installation is most likely 64 bit ( as you have $ORACLE_HOME/lib and $ORACLE_HOME/lib32, check the version of your libclnt.sh with "nm libclntsh.so"

4) If the check above should show 64 bit, then i would suggest
a) Remove export LD_LIBRARY_PATH from your settings
b) Replace in the SHLIB_PATH all references to lib32 through lib (e.g.
SHLIB_PATH=$ORACLE_HOME/lib:/usr/lib:$ORACLE_HOME/rdbms/lib )

Best regards

Maxim Received on Sat May 28 2005 - 11:35:26 CEST

Original text of this message