RE: sqlplus on HP-UX
Date: Mon, 24 Aug 2009 13:08:12 -0400
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.
$ chatr 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
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Maureen English Sent: Monday, August 24, 2009 12:55 PM
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.
http://www.freelists.org/webpage/oracle-l Received on Mon Aug 24 2009 - 12:08:12 CDT