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