Hello Justin,

I've tryied to set TNS_ADMIN and it doesn't work. The application uses a
tnsadmin that is located in a network drive (it's the same for all the
application clients), and not uses the local file. I thought to erase
the shared tnsadmin file and let the system use the Oracle default file,
but I would like to change this file depending on the user that have
logged in the computer, so I would like to use a specified tnsnames.ora
located in the home of every user.

The only option I see is copy the user tnsnames.ora to the Oracle
default location every logon, but I would like not to use this.


Justin Cave (DDBC) wrote:

>You can set the TNS_ADMIN environment variable to point every application on the machine at a single tnsnames.ora file (generally because you have multiple Oracle Homes). You can also override the system's tnsnames.ora file by putting a tnsnames.ora file in the application directory.
>
>Justin Cave
>Distributed Database Consulting, Inc.
>http://www.ddbcinc.com/askDDBC
>
>-----Original Message-----
>From: Andres Martin [mailto:oracledba-ezmlmshield-x94986603.[Email address protected]
>Sent: Thursday, June 02, 2005 11:30 AM
>To: LazyDBA Discussion
>Subject: Specify diferent tnsnames.ora
>
>Hello,
>
>I have an application that runs his own tnsnames file and I want to
>force the system to use a different one. There's any way in
>windows/MSDOS console to force the system to use my tnsnames.ora?
>
>thank you
>
>
>
>


--
Un saludo

Andrés Martín
Dpt. Informática


Oracle LazyDBA home page