Re: Configuring Net*8

You can set the TNS_ADMIN variable in the registry to point to the shared folder. But Net8 will also expect to find SQLNET.ORA in there as well. So you can't set this and expect that Net8 will use TNSNAMES.ORA from one location and SQLNET.ORA in another location.

One other point is that this introduces a single point of failure for your clients. What happens if the server that has the shared folder is down? Or the connection to it is down (i.e. Novell is having problems)? Some sites use software to "push" TNSNAMES.ORA to clients. When the administrator changes the file, the latest and greatest copy is pushed to the clients. Only one change and it's propogated where it needs to be. An example of this push software for Novell is called ZEN Works. There are other solutions too.

HTH,
Brian

Juhan Kundla wrote:
>
> By default the tnsnames.ora file is in the /ORACLE_HOME/net80/admin/
> folder (NT w/s). Is it possible to tell to the net*8 client that the
> tnsnames.ora file is in an alternative folder? I would like to use one
> shared tnsnames.ora on fileserver (NT server), then updating it would be
> much easier. I don't want to use Oracle names server.
>
> TIA,
> Juhan
Received on Thu Feb 03 2000 - 08:02:34 CST