Hi folks,

OS HP-UX 11i
DBMS 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 - 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