RE: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

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 services
---------------------------------------------------------------------
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).