8i fails to find shared libraries
OS HP-UX 11i
DBMS 18.104.22.168 Patchset 2189751
We have just migrated to 8.1.7 (and tomorrow we're getting a telephone!) and have come up against a major pain.
If we try a local connection thorugh SQL*Plus we get :
[hpips2] /home/opdba> sqlplus (user)/(password)
SQL*Plus: Release 22.214.171.124.0 - Production on Wed Mar 26 09:02:50 2003
(c) Copyright 2000 Oracle Corporation. All rights reserved.
/usr/lib/pa20_64/dld.sl: Unable to find library 'libjox8.sl'.
ORA-12547: TNS:lost contact
The LD_LIBRARY_PATH points to $ORACLE_HOME/lib64 and SHLIB_PATH to $ORACLE_HOME/lib. This issue does not arise if we specify a connection string i.e. sqlplus user/password@hpips2_acdev.
Interestingly we can connect successfully if we logon to unix with the account owning the oracle installation regardless of whether we supply a connection string or not.
Kind of suggests a permissions issue (not oracle executable, already checked)but not sure where else to look.
I would check Metalink but the client seems to think that support is a luxury!!!
Any ideas would be a great help