Sqlplus Problem

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 2000/04/12
Message-ID: <8d1fc1$a1n$1@news.liv.ac.uk>#1/1

Hi,

Oracle software and database (8.1.5.1.0) copied from one Solaris 2.6 machine to another. Checked all perms etc all seems OK. Start database OK and can use sqlplus. The problem is if I log in as myself set up the correct environment and sqlplus user/userpass result is:

ld.so.1: oraclexxxx: fatal: libskgxp8.so: open failed: No such file or directory
ERROR: ORA-12547: TNS:lost contact

If set TWO_TASK to xxxx and do exactly as above all is OK as is actioning sqlplus user/userpass_at_xxxx.

ORACLE_SID=xxxx

ORACLE_HOME=/usr/oracle/product/8.1.5

PATH=/usr/local/bin:/usr/local/appsbin:/opt/SUNWmfwm/bin:/usr/openwin/bin:
/opt/SUNWspro/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:.:
/usr/oracle/product/8.1.5/bin

LD_LIBRARY_PATH=/usr/dt/lib:/opt/SUNWmotif/lib:/usr/openwin/lib:
/usr/oracle/product/8.1.5/lib:/usr/oracle/product/8.1.5/network/lib

The so called missing library file is in /usr/oracle/product/8.1.5/lib.

Any ideas as to cause/solution much appreciated.

TIA Helen Received on Wed Apr 12 2000 - 00:00:00 CDT