Home » RDBMS Server » Networking and Gateways » Centralized TNSNAMES.ORA (9.2.0.8 Win2003 Server)
Centralized TNSNAMES.ORA [message #591856] Wed, 31 July 2013 18:15 Go to next message
Amine
Messages: 371
Registered: March 2010
Senior Member

Hi all,
We are running a 9.2.0.8 with client-server application (Forms and Reports 6i).
The forms and reports (*.fmx and *.rep) are located in a shared folder "app" on the machine "serv1".
Clients run the application by mapping a network drive s:\ on \\serv1\app.
To connect to the DB, clients have a TNSNAMES.ORA located on there machine (the TNSNAMES of the forms Runtime).

What I want to do now is to centralize they way they connect to the DB.
I want to put a TNSNAMES.ora on \\serv1\app and force the clients to use this TNSNAMES.ora.

With some clients, the connection was successful but with some others they still use there own TNSNAMES.ora.

How to centralize them all ?
Thanks in advance,

Amine
Re: Centralized TNSNAMES.ORA [message #591857 is a reply to message #591856] Wed, 31 July 2013 18:24 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Oracle client software will look for tnsnames.ora file in directory defined by TNS_ADMIN environmental variable.
Re: Centralized TNSNAMES.ORA [message #591858 is a reply to message #591857] Wed, 31 July 2013 18:28 Go to previous messageGo to next message
Amine
Messages: 371
Registered: March 2010
Senior Member

So no way to centralize then ?
Re: Centralized TNSNAMES.ORA [message #591859 is a reply to message #591858] Wed, 31 July 2013 18:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>So no way to centralize then ?
if every client can access the same folder, then only single copy of tnsnames.ora file needs to exist within that single folder.
Re: Centralized TNSNAMES.ORA [message #591860 is a reply to message #591859] Wed, 31 July 2013 18:39 Go to previous messageGo to next message
Amine
Messages: 371
Registered: March 2010
Senior Member

Every client can access \\serv1\app. I want to centralize the connection to the DB to make the clients TNSNAMES.ORA obsolete.
The clients will still have the service (the application) but they don't know where the data is saved.
Re: Centralized TNSNAMES.ORA [message #591861 is a reply to message #591860] Wed, 31 July 2013 18:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SET TNS_ADMIN=\\SERV1\APP
Re: Centralized TNSNAMES.ORA [message #591862 is a reply to message #591861] Wed, 31 July 2013 18:57 Go to previous messageGo to next message
Amine
Messages: 371
Registered: March 2010
Senior Member

Good. But how to force the clients to set this variable ? I mean they can set it to something else than \\SERV1\APP, how to be sure they point to MY TNSNAMES ?
We can imagine a *.bat file that does it before launching the first *.fmx something like :
SET TNS_ADMIN=\\SERV1\APP
ifrun60.exe app.fmx user/pwd@db

But for now, all the clients have a shortcut to app.fmx. It will be so hard to modify the entry point of all users (about 900 users).
Re: Centralized TNSNAMES.ORA [message #591863 is a reply to message #591862] Wed, 31 July 2013 19:12 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Realize that by refusing to upgrade, you suffer the high cost to support out-dated technology.

The bottom line is that when TNS_ADMIN is not correct, the application ceases to function.
Anyone who willfully breaks the application should just be summarily terminated.
Not every problem requires a technical solution. Personnel policies & procedures can be effective.
Re: Centralized TNSNAMES.ORA [message #591871 is a reply to message #591862] Thu, 01 August 2013 00:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But how to force the clients to set this variable ? I


Set it in the Windows registry.

Regards
Michel
Re: Centralized TNSNAMES.ORA [message #591973 is a reply to message #591871] Thu, 01 August 2013 21:32 Go to previous messageGo to next message
Amine
Messages: 371
Registered: March 2010
Senior Member

Hi Michel,
You mean in the registry of \\SERV1\ or in the registry of each client ?
Re: Centralized TNSNAMES.ORA [message #591981 is a reply to message #591973] Fri, 02 August 2013 00:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Clients, obviously.
Re: Centralized TNSNAMES.ORA [message #591983 is a reply to message #591973] Fri, 02 August 2013 00:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the registry of each client.

Regards
Michel
Re: Centralized TNSNAMES.ORA [message #592609 is a reply to message #591983] Fri, 09 August 2013 17:21 Go to previous message
Amine
Messages: 371
Registered: March 2010
Senior Member

Thank you for the accuracy !
Previous Topic: listener issues
Next Topic: Connection fail two database with identical sid name on different hosts
Goto Forum:
  


Current Time: Thu Mar 28 14:30:15 CDT 2024