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 [EMAIL PROTECTED] 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: '[EMAIL PROTECTED]' 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: <[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).
