Oracle-L: RE: STUPID LD_LIBRARY

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Mon, 06 Oct 2003 12:49:25 -0800
Message-ID: <F001.005D22F6.20031006124925@fatcity.com>

I haven't used or thought about these scripts since version 7.0, until one day last year.

Another DBA at our shop had written a script called "startdb", which starts up your current ORACLE_SID. So, thinking I'd be efficient and save maybe 10 -15 keystokes in starting a database, I type "dbstart".

D'oh!! :P

That script shutdown every instance on the box (6-8 of em'). Luckily it was dev...

Anonymous

-----Original Message-----
Sent: Monday, October 06, 2003 4:24 PM
To: Multiple recipients of list ORACLE-L

	You have listed the reasons why many folks 
	don't use the supplied oraenv scripts. 
	
	It has long been necessary to modify the dbshut and 
	dbstart scripts as well, if you use them, as they have 
	in the past not worked so well. 
	
	Been awhile since I've even used them, so they may 
	have improved while I wasn't looking. 
	
	Jared 
	
	
	
	
	
	<Paula_Stankus_at_doh.state.fl.us>

Sent by: ml-errors_at_fatcity.com

10/06/2003 10:44 AM
Please respond to ORACLE-L

        
        To:        Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com> 
        cc:         
        Subject:        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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Cunningham, Gerald
  INET: Gerald.Cunningham_at_usi.net

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

Received on Mon Oct 06 2003 - 15:49:25 CDT