Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Brian MacLean <bmaclean_at_homebid.com>
Date: Wed, 19 Jul 2000 15:06:12 -0700
Message-Id: <10563.112463@fatcity.com> 





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_01BFF1CD.8EA2B6E2


Content-Type: text/plain;


        charset="windows-1252"



Sorry for the delay in responding (busy..busy...busy)



export


LD_LIBRARY_PATH=/export/home/oracle/app/product/8.1.5/lib:/usr/lib:/usr/loca
l/lib



I also ran into errors on Solaris when I used the /usr/ucb/ld linker.  The
correct linker to use is /usr/ccs/bin/ld



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: James Howerton [mailto:jhowerton_at_uabmc.edu]
Sent: Monday, July 17, 2000 1:39 PM


To: Multiple recipients of list ORACLE-L
Subject: RE: SQL*Plus configuration - Been there/Done that




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



...JIM...


>>> bmaclean_at_homebid.com 7/17/00 1:21:01 PM >>>




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-----


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


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


-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


------_=_NextPart_001_01BFF1CD.8EA2B6E2
Content-Type: text/html;
	charset="windows-1252"
Content-Transfer-Encoding: quoted-printable



<!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>




<P><FONT SIZE=3D2 FACE=3D"Arial">Sorry for the delay in responding =

(busy..busy...busy)</FONT>


</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">export</FONT> <FONT SIZE=3D2 =

FACE=3D"Arial">LD_LIBRARY_PATH=3D/export/home/oracle/app/product/8.1.5/l=
ib:/usr/lib:/usr/local/lib</FONT>


</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">I also ran into errors on Solaris when =

I used the /usr/ucb/ld linker.&nbsp; The correct linker to use is =
/usr/ccs/bin/ld</FONT>


</P>




<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&nbsp; 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: James Howerton [<A =

HREF=3D"mailto:jhowerton_at_uabmc.edu">mailto:jhowerton_at_uabmc.edu</A>]</FON=
T>


<BR><FONT SIZE=3D2 FACE=3D"Arial">Sent: Monday, July 17, 2000 1:39 =

PM</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">To: Multiple recipients of list =

ORACLE-L</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">Subject: RE: SQL*Plus configuration - =

Been there/Done that</FONT>


</P>

<BR>




<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks Brian,</FONT>

</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">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.</FONT></P>



<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks again</FONT>

</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">...JIM...</FONT>

</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">&gt;&gt;&gt; bmaclean_at_homebid.com =

7/17/00 1:21:01 PM &gt;&gt;&gt;</FONT>


</P>

<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"Arial">ld.so.1: oraclePROD: fatal: =

libskgxp8.so: open failed: No such file or</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">directory</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">ERROR:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">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</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">has implemented a security feature in =

that when the Set UID is on the</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">LD_LIBRARY_PATH is for all =

practicable proposes is ignored for non Oracle</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">users.&nbsp; The only LIB's that are =

valid are /usr/lib and the LIB's that are</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">referenced at installation/link time. =

If you want to test this out run the</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">command &quot;ldd -v =

$ORACLE_HOME/bin/oracle&quot;, as the user ORACLE and then as =
one</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">of the users having the problem =

(everyone else), and look for dynamic linker</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">errors.</FONT>

</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">You have three resolution courses. One =

is to create links to all the files</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">in $ORACLE_HOME/lib from =

/usr/lib.&nbsp; This is a bad solution in that if you</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">have two versions of Oracle installed =

you may have conflicts.&nbsp; The second</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">solution is to have your =

LD_LIBRARY_PATH set correct and then relink the</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">Oracle executable.&nbsp; The third is =

to always connect using TWO_TASK or</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">u/p_at_MyTnsAlias (I could explain why =

this one works but I don't have the</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">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><FONT SIZE=3D2 FACE=3D"Arial">Brian P. Mac Lean</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Senior Oracle Database =

Administrator</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">OCPv8/Oracle Master</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">HomeBid.Com</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">8700 N. Gainey Center Drive</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Suite 150</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Scottsdale, AZ&nbsp; 85258</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Tel:480.609.4624</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Cel:602.617.6075</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Fax:480.609.4646</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">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">Sent: Saturday, July 15, 2000 10:45 =

AM</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">To: Multiple recipients of list =

ORACLE-L</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">&nbsp; INET: krasimir_at_rcn.com </FONT>

</P>




<P><FONT SIZE=3D2 FACE=3D"Arial">Fat City Network =

Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: (858) =
538-5051</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">San Diego, =

California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public Internet =
access / Mailing Lists</FONT>


</P>

<BR>




<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: James Howerton</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

jhowerton_at_uabmc.edu</FONT>


</P>



Received on Wed Jul 19 2000 - 17:06:12 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US