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
[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).