RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

This one is incorrect:
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
> export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib

This one is correct:
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

The first one assumes that there is nothing else needed in the LD_LIBRARY_PATH. Could be you need some system libs to do your linking.

Try doing "echo $LD_LIBRARY_PATH" to see what else is in it.

Jared

On Wed, 2003-10-15 at 16:09, Paula_Stankus_at_doh.state.fl.us wrote:
> So the external procedure call not finding a library was due to LD_LIBRARY_PATH. However, I don't understand why:
>
> -----Original Message-----
> Sent: Wednesday, October 15, 2003 5:47 PM
> To: May, James S
> Cc: Yoshikawa, Makoto D; Evans, Russ F
> Subject: remembered - relinking
>
> Guys,
>
> I had to relink a database 9i 64-bit database on swas04 which I was not able to do until I changed the LD_LIBRARY_PATH and that is the original reason I changed the LD_LIBRARY_PATH and according to following instructions:
>
> Oracle 9.X.X (64Bit) on Solaris (64Bit) OS
> - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32
> - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
>
> My thinking was that setting:
>
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
> export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
>
> versus:
> export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
>
> Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH. I am not sure how taking that one part out and commenting out
>
> #export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
>
> would make a difference
>
> I still am confused as to why taking these changes fixed the problem.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <Paula_Stankus_at_doh.state.fl.us
> INET: Paula_Stankus_at_doh.state.fl.us
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).