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


> Is it possible to specify a different  TNS_ADMIN directory for each SID?

>

> John

>

>