Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Plus configuration - Been there/Done that

RE: SQL*Plus configuration - Been there/Done that

From: James Howerton <>
Date: Mon, 17 Jul 2000 14:27:51 -0500
Message-Id: <>

Thanks Brian,

I'm getting this error after re-linking to use Sun's netbackup with rman. = This is a SGI box but I think its the same problem. Please send me an = example of your LD_LIBRARY_PATH so I can compare it to the one I'm using.

Thanks again

>>> 7/17/00 1:21:01 PM >>>

I ran into this same error a while ago. It looked something like: oraclePROD: fatal: open failed: No such file or directory
ORA-12547: TNS:lost contact

If this is the error and the platform is Solaris then the reason is that = Sun
has implemented a security feature in that when the Set UID is on the LD_LIBRARY_PATH is for all practicable proposes is ignored for non Oracle users. The only LIB's that are valid are /usr/lib and the LIB's that are referenced at installation/link time. If you want to test this out run the command "ldd -v $ORACLE_HOME/bin/oracle", as the user ORACLE and then as = one
of the users having the problem (everyone else), and look for dynamic = linker

You have three resolution courses. One is to create links to all the files in $ORACLE_HOME/lib from /usr/lib. This is a bad solution in that if you have two versions of Oracle installed you may have conflicts. The second solution is to have your LD_LIBRARY_PATH set correct and then relink the Oracle executable. The third is to always connect using TWO_TASK or u/p_at_MyTnsAlias (I could explain why this one works but I don't have the time).=20

We relinked.

BOL Brian P. Mac Lean
Senior Oracle Database Administrator
OCPv8/Oracle Master
8700 N. Gainey Center Drive
Suite 150
Scottsdale, AZ 85258


-----Original Message-----
Sent: Saturday, July 15, 2000 10:45 AM
To: Multiple recipients of list ORACLE-L

I've set up my $LD_LIBRARY_PATH environment variable to the location of the library files necessary for SQL*Plus and other tools: echo $LD_LIBRARY_PATH retrieves /u01/app/oracle/product/8.1.5/lib - the path where files like reside.

Yet when I try to envoke sqlplus I get an error : error in loading shared libraries: cannot open shared object file:

This is happenning for Oracle 8i users other than the oracle user itself. When I installed Oracle 8.1.5 on my Linux box I dealt with the above problem for the oracle user and resolved it (I believe by setting LD_LIBRARY_PATH correctly). I tried to duplicate oracle's environment for the problematic users, but that didn't help.

Any ideas?

Thank you,

Krassimir Georgiev

Author: Krasimir Georgiev

Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 Received on Mon Jul 17 2000 - 14:27:51 CDT

Original text of this message