RE: sqlplus on HP-UX
Date: Mon, 24 Aug 2009 13:08:12 -0400
Message-ID: <9B91048922998049A2BED0F0745FB4A909DAE440_at_LOUMLVEM03.e2k.ad.ge.com>
Try running 'chatr sqlplus' in both environments and examing the top few lines to see what happens if the LD_LIBRARY_PATH is not set. If SHLIB_PATH searching is enabled, see what the value of that environmental variable is.
Example:
$ chatr sqlplus
sqlplus:
64-bit ELF executable
shared library dynamic path search:
LD_LIBRARY_PATH enabled first
SHLIB_PATH enabled second
embedded path enabled third
/oracle/10.2.0/sqlplus/lib/:/oracle/10.2.0/lib/:/usr/lib/hpux64:/opt/lan
gtools/lib/hpux64
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Maureen English
Sent: Monday, August 24, 2009 12:55 PM
To: oracle-l_at_freelists.org
Subject: sqlplus on HP-UX
We have Oracle release 10.2.0.3.0 and 10.2.0.4.0 on our HP-UX and HP Tru64 machines. I found something very strange, though, on the HP-UX machines.
On the HP-UX machines, if our LD_LIBRARY_PATH is set to the 10.2.0.3.0/lib, when we start sqlplus, even though ORACLE_HOME and PATH variables are correctly pointing to 10.2.0.4.0, the version of sqlplus that is started is the 10.2.0.3.0 version. If LD_LIBRARY_PATH is not set at all, or is set to 10.2.0.4.0/lib, then the correct version of sqlplus is started.
On the HP Tru64 machines, the correct version of sqlplus is started no matter what we set LD_LIBRARY_PATH to.
I do know that we really should set LD_LIBRARY_PATH in all cases, but due to an oversight, it wasn't being set in our database startup scripts. So, now I'm just curious as to why we are now seeing a different behavior.
Any comments?
- Maureen
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 24 2009 - 12:08:12 CDT