| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Plus configuration - Been there/Done that
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF012.3BB69604
Content-Type: text/plain;
charset="windows-1252"
I ran into this same error a while ago. It looked something like:
ld.so.1: oraclePROD: fatal: libskgxp8.so: open failed: No such file or
directory
ERROR:
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 errors.
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).
We relinked.
BOL
Brian P. Mac Lean
Senior Oracle Database Administrator
OCPv8/Oracle Master
HomeBid.Com
8700 N. Gainey Center Drive
Suite 150
Scottsdale, AZ 85258
Tel:480.609.4624 Cel:602.617.6075 Fax:480.609.4646 Net:brian.maclean_at_homebid.com
-----Original Message-----
From: Krasimir Georgiev [mailto:krasimir_at_rcn.com]
Sent: Saturday, July 15, 2000 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: SQL*Plus configuration
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
libskgxp8.so reside.
Yet when I try to envoke sqlplus I get an error : error in loading shared libraries: cannot open shared object file: libskgxp8.so
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
krasimir_at_rcn.com
-- Author: Krasimir Georgiev INET: krasimir_at_rcn.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists ------_=_NextPart_001_01BFF012.3BB69604 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printableReceived on Mon Jul 17 2000 - 12:12:48 CDT
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dwindows-1252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: SQL*Plus configuration - Been there/Done that</TITLE>
</HEAD>
<BODY>
<BR>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">I ran into this same error a while =
ago. It looked something like:</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Courier New">ld.so.1: oraclePROD: fatal: =
libskgxp8.so: open failed: No such file or directory</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">ERROR:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Courier New">ORA-12547: TNS:lost =
contact</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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 errors.</FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">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). </FONT></P>
<P><FONT SIZE=3D2 FACE=3D"Arial">We relinked.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">BOL</FONT>
</P>
<BR>
<P><B><FONT COLOR=3D"#0000FF" FACE=3D"Comic Sans MS">Brian P. Mac =
Lean</FONT></B>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">Senior =
Oracle Database Administrator</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">OCPv8/Oracle Master</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">HomeBid.Com</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">8700 N. =
Gainey Center Drive</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">Suite =
150</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans MS">Scottsdale, =
AZ 85258</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Tel:480.609.4624</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Cel:602.617.6075</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Fax:480.609.4646</FONT>
<BR><FONT COLOR=3D"#808080" SIZE=3D1 FACE=3D"Comic Sans =
MS">Net:brian.maclean_at_homebid.com</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">From: Krasimir Georgiev [<A =
HREF=3D"mailto:krasimir_at_rcn.com">mailto:krasimir_at_rcn.com</A>]</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Sent: Saturday, July 15, 2000 10:45 =
AM</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">To: Multiple recipients of list =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Subject: SQL*Plus =
configuration</FONT>
</P>
<BR>
<P><FONT SIZE=3D2 FACE=3D"Arial">I've set up my $LD_LIBRARY_PATH =
environment variable to the location of</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">the library files necessary for =
SQL*Plus and other tools:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">echo $LD_LIBRARY_PATH retrieves =
/u01/app/oracle/product/8.1.5/lib - the</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">path where files like</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">libskgxp8.so reside.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Yet when I try to envoke sqlplus I get =
an error : error in loading</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">shared libraries: cannot open shared =
object file: libskgxp8.so</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">This is happenning for Oracle 8i users =
other than the oracle user</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">itself. When I installed Oracle 8.1.5 =
on my Linux box I dealt with the</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">above problem for the oracle user and =
resolved it (I believe by setting</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">LD_LIBRARY_PATH correctly). I tried =
to duplicate oracle's environment</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">for the problematic users, but that =
didn't help.</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Any ideas?</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Thank you,</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Krassimir Georgiev</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">krasimir_at_rcn.com</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Krasimir Georgiev</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial"> INET: krasimir_at_rcn.com</FONT>
</P>
<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =
Services -- (858) 538-5051 FAX: (858) = 538-5051</FONT>
 |
 |