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

I think the best way to do it, use Oracle Names. In this case you will not need TNSNAMES.ORA on a client (only SQLNET.ORA).

Eugene.

-- 
********************************************************
*        Everything above is only my opinion           *
********************************************************
*						       *
* If you see a lion in a cage and sign says "elephant" * 
*                      ,                               *
*           DO not belive your eyes !                  *
*       (Kozma Prutkov. (informal translation))        *
*                                                      *
********************************************************