Add the TNS_ADMIN parameter to change the default directory location for
configuration files.
For Microsoft platforms:
1. Open the oracle.key file located in the <ORACLE_HOME>\bin directory.
This file contains the location of Oracle variables in the registry.
2. Run regedt32.exe
3. Add the TNS_ADMIN environment variable to
KEY_LOCAL_MACHINE\Software\Oracle[\HOME[x]]. The exact location is
found from step 1.
4. Use the Registry Editor's EDIT|Add Value menu to add the TNS_ADMIN
parameter. The data type should remain as REG_SZ. The "String"
should
be set to the location of the Oracle configuration files.
5. TNS_ADMIN can also be set as a system wide or global variable within
the operating system.
For UNIX platforms:
Add the TNS_ADMIN environment variable using 'setenv' or 'export'.
In C shell use 'setenv'
% setenv TNS_ADMIN <ORA_file_directory>}
In K shell use 'export'
% TNS_ADMIN=<ORA_file_directory>
% export TNS_ADMIN
Example:
setenv TNS_ADMIN /var/opt/oracle/temp
Regards,
Gadi Chen
Oracle DBA -Enterprise Architecture
Partner OrangeTM
|||||||||
( '©-©' )
----ooO-(_)-Ooo-----
Cell : 054-360397
phone: 067-815223
fax: 067-814714
Gadi.[Email Address Removed]
-----Original Message-----
From: Ofer Harel [mailto:[Email Address Removed] Thursday, November 27, 2003 17:40
To: LazyDBA.com Discussion
Subject: Changing the location of the tnsnames.ora
Good morning,
I would appreciate to know exact syntax and location of the registry key
TNS_ADMIN which change the location of the tnsnames.ora file, i.e., instead
of ~oracle_home/network/admin.
sincerely
Ofer Harel
DBA team
Barak ITC
[Email Address Removed] information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp. Ltd.
**********************************************************************
--------
Get today's cartoon: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] using this list you agree to these terms:http://www.lazydba.com/legal.html
---------------------------------------------------------------------------------------------------------------
This message contains information that may be confidential or privileged.
If you are not the intended recipient, you may not use, copy or disclose
to anyone any of the information in this message. If you have received
this message and are not the intended recipient, kindly notify the sender
and delete this message from your computer.
Oracle LazyDBA home page