Is this application running on the client? Or is a three-tiered application that has a middle tier component somewhere else?

Are you sure that the TNS_ADMIN environment variable is set and the directory it points to is available before the application starts? Life is obviously more complicated if you've got services/daemons that are always running and you're mapping drives and setting up environment variables in login scripts.

Normally, sites using tnsnames.ora files lament the pain of trying to ensure that everyone in the organization has the same tnsnames.ora file. I'm a bit curious as to why you want to go the other way, ensuring that everyone can have a different file if they would like. That seems a bit counterintuitive to me.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Andres Martin [mailto:oracledba-ezmlmshield-x7212533.[Email address protected]
Sent: Thursday, June 02, 2005 11:52 AM
To: LazyDBA Discussion
Subject: Re: Specify diferent tnsnames.ora

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



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page