Yes, the tnsadmin.ora is located in the network drive, into the
directory of the applications where the executable resides.

Justin Cave (DDBC) wrote:

>So, we're dealing with a client-server application running on the client machine. And it uses a tnsnames.ora file located on a network drive regardless of the TNS_ADMIN environment variable on the client machine? Is the application running from that same network drive? In other words, is the tnsnames.ora file that is being used in the same directory as the application executable?
>
>Justin Cave
>Distributed Database Consulting, Inc.
>http://www.ddbcinc.com/askDDBC
>
>-----Original Message-----
>From: Andres Martin [mailto:oracledba-ezmlmshield-x38896582.[Email address protected]
>Sent: Thursday, June 02, 2005 12:14 PM
>To: LazyDBA Discussion
>Subject: Re: Specify diferent tnsnames.ora
>
>Yes, I have set up TNS_ADMIN correctly. There is no daemons running,
>it's a very simple application.
>
>I work for a company that have an application that uses Oracle, and I
>would like to connect different sections in shared mode and other in
>dedicated mode. Right now all people (about 150 users) runs in dedicated
>mode and Oracle is going down every minute and I don't want to connect
>all people in shared mode.
>
>Now I've tried to erase the application tnsadmin file and when it tryes
>to use my tnsnames.ora the server tell me that the session is running in
>NONE, when I've specified shared.
>
>There is my tnsnames.ora:
>
>TEST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = yoda)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = TEST)
> (SERVER = SHARED)
> )
> )
>
>What's the meaning of NONE server?
>
>
>Justin Cave (DDBC) wrote:
>
>
>
>>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


Oracle LazyDBA home page