RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-16 Thread Paula_Stankus
Thanks Jared,

Would
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:
 export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib

also be correct?

-Original Message-
Sent: Thursday, October 16, 2003 1:59 AM
To: Multiple recipients of list ORACLE-L


This one is incorrect:

This one is correct:
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

The first one assumes that there is nothing else needed in 
the LD_LIBRARY_PATH.  Could be you need some system libs to
do your linking.

Try doing echo $LD_LIBRARY_PATH to see what else is in it.

Jared



On Wed, 2003-10-15 at 16:09, [EMAIL PROTECTED] wrote:
 So the external procedure call not finding a library was due to LD_LIBRARY_PATH.  
 However, I don't understand why:
 
  -Original Message-
 Sent: Wednesday, October 15, 2003 5:47 PM
 To:   May, James S
 Cc:   Yoshikawa, Makoto D; Evans, Russ F
 Subject:  remembered - relinking
 
 Guys,
 
 I had to relink a database 9i 64-bit database on swas04 which I was not able to do 
 until I changed the LD_LIBRARY_PATH and that is the original reason I changed the 
 LD_LIBRARY_PATH and according to following instructions:
 
 Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
 - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
 - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 
 
 My thinking was that setting:
 
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
 export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 versus:
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 
 Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH.  I am not sure 
 how taking that one part out and commenting out 
 
 #export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 would make a difference
 
 I still am confused as to why taking these changes fixed the problem.  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-16 Thread Jared Still

Ah, my mistake.

Last night I missed the fact that the first one *does*
have LD_LIBRARY_PATH in it.

Having both the 32 and 64 bit libs in the path could
have been your problem.

Jared


On Wed, 2003-10-15 at 22:59, Jared Still wrote:
 This one is incorrect:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
  export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 
 This one is correct:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 
 The first one assumes that there is nothing else needed in 
 the LD_LIBRARY_PATH.  Could be you need some system libs to
 do your linking.
 
 Try doing echo $LD_LIBRARY_PATH to see what else is in it.
 
 Jared
 
 
 
 On Wed, 2003-10-15 at 16:09, [EMAIL PROTECTED] wrote:
  So the external procedure call not finding a library was due to LD_LIBRARY_PATH.  
  However, I don't understand why:
  
   -Original Message-
  Sent:   Wednesday, October 15, 2003 5:47 PM
  To: May, James S
  Cc: Yoshikawa, Makoto D; Evans, Russ F
  Subject:remembered - relinking
  
  Guys,
  
  I had to relink a database 9i 64-bit database on swas04 which I was not able to do 
  until I changed the LD_LIBRARY_PATH and that is the original reason I changed the 
  LD_LIBRARY_PATH and according to following instructions:
  
  Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
  - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
  - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 
  
  My thinking was that setting:
  
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
  export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
  
  versus:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
  
  Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH.  I am not 
  sure how taking that one part out and commenting out 
  
  #export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
  
  would make a difference
  
  I still am confused as to why taking these changes fixed the problem.  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jared Still
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-16 Thread Stephen Lee

If you want a safe way and you are using ksh, you can always use

${LD_LIBRARY_PATH:-/usr/lib}

in the list following the = sign.

That way, you always have something defined
And when nothing is defined, /usr/lib is the default, so you really haven't
changed anything by putting it in.

 -Original Message-
 
 Thanks Jared,
 
 Would
  export 
 LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$LD_LIBRARY_PATH:
  export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 also be correct?
 
 -Original Message-
 Sent: Thursday, October 16, 2003 1:59 AM
 To: Multiple recipients of list ORACLE-L
 
 
 This one is incorrect:
 
 This one is correct:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 
 The first one assumes that there is nothing else needed in 
 the LD_LIBRARY_PATH.  Could be you need some system libs to
 do your linking.
 
 Try doing echo $LD_LIBRARY_PATH to see what else is in it.
 
 Jared
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-16 Thread Paula_Stankus
Apparently was but my understanding of paths is that it goes from first directory 
listed ...down and so it should have picked up the 64 bit 


-Original Message-
Sent: Thursday, October 16, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L



Ah, my mistake.

Last night I missed the fact that the first one *does*
have LD_LIBRARY_PATH in it.

Having both the 32 and 64 bit libs in the path could
have been your problem.

Jared


On Wed, 2003-10-15 at 22:59, Jared Still wrote:
 This one is incorrect:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
  export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 
 This one is correct:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 
 The first one assumes that there is nothing else needed in 
 the LD_LIBRARY_PATH.  Could be you need some system libs to
 do your linking.
 
 Try doing echo $LD_LIBRARY_PATH to see what else is in it.
 
 Jared
 
 
 
 On Wed, 2003-10-15 at 16:09, [EMAIL PROTECTED] wrote:
  So the external procedure call not finding a library was due to LD_LIBRARY_PATH.  
  However, I don't understand why:
  
   -Original Message-
  Sent:   Wednesday, October 15, 2003 5:47 PM
  To: May, James S
  Cc: Yoshikawa, Makoto D; Evans, Russ F
  Subject:remembered - relinking
  
  Guys,
  
  I had to relink a database 9i 64-bit database on swas04 which I was not able to do 
  until I changed the LD_LIBRARY_PATH and that is the original reason I changed the 
  LD_LIBRARY_PATH and according to following instructions:
  
  Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
  - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
  - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 
  
  My thinking was that setting:
  
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
  export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
  
  versus:
  export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
  
  Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH.  I am not 
  sure how taking that one part out and commenting out 
  
  #export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
  
  would make a difference
  
  I still am confused as to why taking these changes fixed the problem.  
  -- 
  Please see the official ORACLE-L FAQ: http://www.orafaq.net
  -- 
  Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
  
  Fat City Network Services-- 858-538-5051 http://www.fatcity.com
  San Diego, California-- Mailing list and web hosting services
  -
  To REMOVE yourself from this mailing list, send an E-Mail message
  to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
  the message BODY, include a line containing: UNSUB ORACLE-L
  (or the name of mailing list you want to be removed from).  You may
  also send the HELP command for other information (like subscribing).
  
 
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Jared Still
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-15 Thread Paula_Stankus
So the external procedure call not finding a library was due to LD_LIBRARY_PATH.  
However, I don't understand why:

 -Original Message-
Sent:   Wednesday, October 15, 2003 5:47 PM
To: May, James S
Cc: Yoshikawa, Makoto D; Evans, Russ F
Subject:remembered - relinking

Guys,

I had to relink a database 9i 64-bit database on swas04 which I was not able to do 
until I changed the LD_LIBRARY_PATH and that is the original reason I changed the 
LD_LIBRARY_PATH and according to following instructions:

Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
- Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
- Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 

My thinking was that setting:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib

versus:
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH.  I am not sure 
how taking that one part out and commenting out 

#export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib

would make a difference

I still am confused as to why taking these changes fixed the problem.  
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: [EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


RE: I HATE ORACLE LD_LIBRARY PATH - GRRR!!!

2003-10-15 Thread Jared Still
This one is incorrect:
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
 export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib


This one is correct:
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

The first one assumes that there is nothing else needed in 
the LD_LIBRARY_PATH.  Could be you need some system libs to
do your linking.

Try doing echo $LD_LIBRARY_PATH to see what else is in it.

Jared



On Wed, 2003-10-15 at 16:09, [EMAIL PROTECTED] wrote:
 So the external procedure call not finding a library was due to LD_LIBRARY_PATH.  
 However, I don't understand why:
 
  -Original Message-
 Sent: Wednesday, October 15, 2003 5:47 PM
 To:   May, James S
 Cc:   Yoshikawa, Makoto D; Evans, Russ F
 Subject:  remembered - relinking
 
 Guys,
 
 I had to relink a database 9i 64-bit database on swas04 which I was not able to do 
 until I changed the LD_LIBRARY_PATH and that is the original reason I changed the 
 LD_LIBRARY_PATH and according to following instructions:
 
 Oracle 9.X.X (64Bit) on Solaris (64Bit) OS 
 - Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32 
 - Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib 
 
 My thinking was that setting:
 
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:$ORACLE_HOME/lib32
 export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 versus:
 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
 
 Would only add the lib32 libraries at the end of the LD_LIBRARY_PATH.  I am not sure 
 how taking that one part out and commenting out 
 
 #export LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
 
 would make a difference
 
 I still am confused as to why taking these changes fixed the problem.  
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: [EMAIL PROTECTED]
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jared Still
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).