Re: Oracle variables; LD_LIBRARY_PATH & TNS_ADMIN

In /etc you should have an oratab file. It should look like this:

# <oracle notes and stuff>
#
# The line below with the * instead of a sid is for use with tools such as
# OEM and Orasoft. It can be used in scripts for setting the environment
# like the one shown below.

*:/usr/oracle/product/8.1.7:N

<sid for 8.1.7 db>:/usr/oracle/product/8.1.7:N
<sid1 for 8.0.5 db>:/usr/oracle/product/8.0.5:N
<sid2 for 8.0.5 db>:/usr/oracle/product/8.0.5:N
<sid2 for 8.1.7 db>:/usr/oracle/product/8.0.5:N

The oraenv file is located in the /usr/local/bin directory. To run it, export your sid then type .oraenv and answer the prompt.

When I scritp things I usually use a wrapper file to start them off. Here is what I use on my Linux desktop to kick off OEM SQL*Plus Worksheet:

#!/bin/ksh

#
# File: /usr/local/bin/oemworksheet.ksh
# Description: Wrapper for OEM Worksheet
#

export LD_LIBRARY_PATH=/usr/local/lib:/usr/oracle/product/8.1.7/lib export TNS_ADMIN=/usr/oracle/network/admin export ORACLE_SID="*"
export ORAENV_ASK=NO;
. /usr/local/bin/oraenv
# The following line puts me in the directory where my scripts are at.
# When I use the File|Open command I'm where I want to be.
cd /usr/oracle/admin/common
/usr/oracle/product/8.1.7/bin/oemapp worksheet

The ORAENV_ASK variable is a way of making oraenv non-interactive for scripting purposes. It will execute the environment using the sid variable preceeding it.

HTH On Wednesday 28 March 2001 22:55, you wrote:

> 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

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