OraFAQ Forum: Networking and Gateways » tns

Home » RDBMS Server » Networking and Gateways » tns_admin (windows xp oacle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

tns_admin [message #564657]

Mon, 27 August 2012 07:12

mrdb
Messages: 62
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.

Report message to a moderator

Re: tns_admin [message #564660 is a reply to message #564657]

Mon, 27 August 2012 07:15

Michel Cadot
Messages: 68168
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

Report message to a moderator

Re: tns_admin [message #564665 is a reply to message #564660]

Mon, 27 August 2012 07:25

mrdb
Messages: 62
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)

Report message to a moderator

Re: tns_admin [message #564668 is a reply to message #564665]

Mon, 27 August 2012 07:40

Michel Cadot
Messages: 68168
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 24 10:55:34 CDT 2022