Re: Oracle variables; LD_LIBRARY_PATH & TNS_ADMIN

Rodd,

Thanks for the great info. This is good piece of info.

I need to know how I can use "oraenv" utility on unix machine. All the info. I need is for unix (sorry did not specify). Also I am trying to set the LD_LIBRARY_PATH via a unix shell script, so I think I can do a "setenv $LD_LIBRARY_PATH". Is that correct?

Also I want to know, what is I dont set the LD_LIBRARY_PATH, then what happens, will the Oracle sqlplus session start? (Yes/No)? explain if you can...

Also can I do "oraenv $LD_LIBRARY_PATH" in my unix script?

Regrads,

Raja

--

On Wed, 28 Mar 2001 05:46:23  
 Rodd Holman wrote:


>Oracle, by default, uses $ORACLE_HOME/network/admin to stor the tnsnames.ora, 

>sqlnet.ora, listener.ora, snmpro.ora and snmprw.ora files for configuration 

>of the Net8 services.  If you declare a TNS_ADMIN variable oracle will use 

>that location for these files.  It allows you to keep your networking config 

>files separate from the oracle distribution files.  Example:  On our 

>development machines we have multiple oracle homes of diferent versions 

>8.0.x, 8.1.7, etc.  All these versions use the same TNS files from a 

>directory under the $ORACLE_BASE.  Our setup is:

>/usr/oracle

>       admin

>               common

>               <SID>

>       product

>               8.0.5.1

>               8.1.7

>               jre

>               oui

>               oraInventory

>       network

>               admin

>               log

>               trace

>We then use the 8.1.7 listener and OEM agent against all db's.  We have one 

>sqlnet.ora and tnsnames.ora configuration for all instances on the machine.  

>One place for log and trace files for TNS issues.  It makes administration 

>easier.

>

>The LD_LIBRARY_PATH is a variable that tells applications working with the 

>oracle client where the oracle libraries are.  It is version dependent and 

>should be set with the oraenv.  Normally it is $ORACLE_HOME/lib.

>

>If you are not using oraenv then you need to make sure that it is exported 

>before you start doing your oracle stuff.  All of this assumes that you are 

>working with oracle on a Unix machine.

>

>The discussion applies to NT also except these variables are specified in the 

>registry under \\HKEY_LOCAL_MACHINE\Software\Oracle

>

>HTH

>

>On Wednesday 28 March 2001 04:00, you wrote:

>> Hello,

>>

>>

>> I need some clarification. What is the significance of the Oracle

>> variables, TNS_ADMIN & LD_LIBRARY_PATH?

>>

>> When are the 2 used or what effects what in the environment?

>>

>> Also please if some one knows how do I monitor an Oracle Parallel Server?

>> Any good book where I can read about OPS?

>>

>> Regards,

>>

>> Raja

>>

>>

>>

>>

>> Get 250 color business cards for FREE! at Lycos Mail

>> http://mail.lycos.com/freemail/vistaprint_index.html

>

>-- 

>Rodd Holman

>Oracle DBA

>(605) 988-1373

>rodney.holman_at_lodgenet.com

>Comments made are my own opinions and views. They do not represent views, 

>policies, or procedures of LodgeNet Entertainment Corporation

>

>

>-- 

>Please see the official ORACLE-L FAQ: http://www.orafaq.com

>-- 

>Author: Rodd Holman

>  INET: rodney.holman_at_lodgenet.com

>

>Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

>San Diego, California        -- Public Internet access / Mailing Lists

>--------------------------------------------------------------------

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

>



Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Viraj Luthra
  INET: viraj999_at_lycos.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).