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