Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS_ADMIN and SID
John,
(All assuming UNIX)
You can supply a different TNS_ADMIN for each of the databases at the
startup of the database. I have done this for security reasons and
controlling of the database links, or setting up Test systems to mock
Production.
You can set the TNS_AMDIN prior to the start of the database. I use the oraenv program to setup my environment and use the following convention for the TNS directories: /var/opt/oracle/{SID} and added the line to my oraenv program:
export TNS_AMDIN=/var/opt/oracle/${ORACLE_SID}
At the start of the database, this is the TNSNAMES file the database will use. You can then change the environment variable accordingly. Of course you should always test it before continuing in produciton.
Thanks,
Bryan
-- Bryan Michael Lenihan Oracle Certified Professional - DBA (Ver. 7.3, 8) Western Data Systems Technical Services 26707 Agoura Road, Suite 200 Calabasas, CA 91302 "John Dunn" <JLDunn_at_ukgateway.net> wrote in message news:3af07808$0$12241$cc9e4d1f_at_news.dial.pipex.com...Received on Fri May 04 2001 - 15:23:10 CDT
> Is it possible to specify a different TNS_ADMIN directory for each SID?
>
> John
>
>