Re: TNSNAMES.ORA

Shah Vijay wrote:
>
> Is there a way to put a common TNSNAMES.ORA file on NT server that each
> client may read, as opposed to having a local copy for each client in
> the ORANT(ORAWIN)\NETWORK\ADMIN directory. The reason for this is that
> each time a new instance is created, that the client will access, the
> TNSNAMES.ORA has to be updated. The idea is to avoid updation of this
> file on each client (potentially a large no of).
>
> Any insight will be greatly appreciated.
>
> avisha_at_ix.netcom.com

The 'Oracle' solution for this is the Names Server (included in the NT version, btw)

The short answer to your question is no, since I understand SQL*Net bases itself off the ORACLE_HOME directory. Therefore, you would have to run all client Oracle pieces off the NT server to do this.

Regards,
jh

--
Jared Hecker          | DB Consulting (modelling and DBA, Oracle/Sybase)
hecker_at_toysrus.com   |  on assignment
jared_at_hwai.com        |  back at the ranch...