Home » RDBMS Server » Networking and Gateways » tns_admin (windows xp oacle 10g)
tns_admin [message #564657] Mon, 27 August 2012 07:12 Go to next message
mrdb
Messages: 60
Registered: December 2009
Location: dubai
Member

We are using oracle 10g database, and forms6i front end. user are connecting to the oracle database through the tnsnames in there system.Now we are going to change the server so there is a need to change tnsnames in each users pc. Is there any option to keep the tnsnames centralized so that users will use that, in case of changes we can change at one place only.
Any solution is highly appreciated.
Re: tns_admin [message #564660 is a reply to message #564657] Mon, 27 August 2012 07:15 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a network shared disk to store your tnsnames.ora file and, indeed, configure and use TNS_ADMIN on your clients.

Regards
Michel
Re: tns_admin [message #564665 is a reply to message #564660] Mon, 27 August 2012 07:25 Go to previous messageGo to next message
mrdb
Messages: 60
Registered: December 2009
Location: dubai
Member

Mr.Michel
I followed these steps
is this right.
1.MY COMPUTER
2.PROPERTIES
3.ADVANCED
4.ENVIROMENTAL VRIABLE
5.VARIABLE NAME =TNS_ADMIN
6.VARIABLE VALUES =\\SYSTEMNAME\FOLDER\TNSNAMES.ORA (which is sharing folder in the network)
Re: tns_admin [message #564668 is a reply to message #564665] Mon, 27 August 2012 07:40 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm not sure Oracle supports UNC, you have to test it.
If it doesn't then you have to set a network disk in client profile.

Note that it is easier to set TNS_ADMIN in registry when you install (or upgrade the client), HKLM\Software\Oracle\<your Oracle home name>.

Regards
Michel
Previous Topic: How to find all the objects referring to DB Link
Next Topic: port forwarding in oracle 10g
Goto Forum:
  


Current Time: Wed Apr 16 15:47:55 CDT 2014

Total time taken to generate the page: 0.13392 seconds