| 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: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!
Hehe
Found a posting from Michael Ault on same subject. Michael - are you there?
Thread Status: Active
RDBMS Version: 9.2.0.1
Operating System and Version: Solaris 2.8 64 bit
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.): OCI
Product Version: 9.2.0.1
Library Paths 32 bit on 64 bit 9.2.0.1 Solaris 2.8
I have been through about 16 different postings on this topic concerning linking/using 32 bit applications on 64 bit Oracle. The situation here is that the applicaiton ran fine against 8.1.7.4 64 bit with /lib as 32 bit and /lib64 as 64 bit now Oracle gets a bee and makes the libraries /lib a 64 bit and /lib32 as 32 bit and every thing breaks. Come on Oracle get a clue, don't mess with such basic things as library directory names! Geesh!
Now every other post seems to contridict each other:
Set LD_LIBRARY_PATH with $ORACLE_HOME/lib and not with lib32 Set SHLIB_PATH with $ORACLE_HOME/lib32 and not lib
Set LD_LIBRARY_PATH with both
Unset LIBPATH
Set LD_LIBRARY_PATH with /lib32 first, then /lib
No...do it the other way
and last but not least:
LD_LIBRARY_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/ctx/lib LD_LIBRARY_PATH_64=$ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
(Where in the heck did LD_LIBRARY_PATH_64 come from? And why is it not mentioned in any other post about this?)
Anyway, which is correct for running a prelinked 32 bit application using OCI against a 9.2.0.1 Oracle 64 bit database on Solaris 2.8?
And, where can I get a proper coly of the ldflags file for the lib32 directory?
Mike
Micheal,
bet you a pint you'll see this as a bug fix in 9.2.0.3
Andrew Parkyns
Senior DBA
Thomson Derwent
andrew.parkyns_at_derwent.co.uk
P.S. do you ascribe to the "Oracle version skipping theory" e.g. bug in 8.1.6.1 fixed in 8.1.6.3 recurs in 8.1.7.0, fix backported from 9.0.1, bug recurs in 9.2.0.1 .... fixed in 9.2.0.3 ? You could give it a try.
Yep...sure do. Just a pint?
Mike
Hi,
Kindly post your queries to OCI forum.
Thanks
Niranjan
Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.
-----Original Message-----
Sent: Monday, October 06, 2003 12:42 PM
To: 'ORACLE-L_at_fatcity.com'
Guys,
I setup lsnrstart....stop scripts for root that does the su -c to oracle and runs them. I could run as oracle successfully but using the su - c command brought me this error:
"Oracle ld.so.1: /opt/oracle/product/9.2.0/bin/lsnrctl: fatal: libclntsh.so.9.0: open failed: No such file or directory /usr/oracle/tools/bin/lsnrstart[12]: 398 Killed"
I quickly verified that the file libclntsh.so.0.0 existed. Therefore, I felt that it might have something to do with relinking.
I tried relinking after shutting everything down and got the same type of ld.so.1 error. Then with my experience I realized that this usually related to LD_LIBRARY_PATH. I looked up relinking and found a note that states this:
Doc ID: Note:131321.1
The note says:
Oracle 9.X.X (64Bit) on Solaris (64Bit) OS
- Set LD_LIBRARY_PATH=$ORACLE_HOME/lib32
- Set LD_LIBRARY_PATH_64=$ORACLE_HOME/lib
I did this and it worked.
I then verified that Oracle's environmental scripts (out-of-the-box) set LD_LIBRARY_PATH as I have always used these environment scripts. However, they do not set the path as listed above. In fact, the environment variable will overwrite LD_LIBRARY_PATH to the wrong setting.
So, do I set LD_LIBRARY_PATH as above, I am a little confused since the environment script and this note do not match as to which setting is correct. For relinking I definitely know only the one above will work!!!!!! GRRRRRRRR!!!!!!!!!!!!
Any opinions?
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <Paula_Stankus_at_doh.state.fl.us INET: Paula_Stankus_at_doh.state.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting servicesReceived on Mon Oct 06 2003 - 13:34:32 CDT
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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).
 |
 |