Home » Infrastructure » Windows » TNS_ADMIN
TNS_ADMIN [message #455704] Wed, 12 May 2010 10:45 Go to next message
venkatshrikant
Messages: 1
Registered: May 2010
Junior Member
How to find the entry for variable "TNS_ADMIN" for oracle 9i in windows machine.

Kindly provide the solution. It is urgent.
Re: TNS_ADMIN [message #455706 is a reply to message #455704] Wed, 12 May 2010 11:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
just execute:
set

Regards
Michel
Re: TNS_ADMIN [message #455719 is a reply to message #455706] Wed, 12 May 2010 12:28 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
"SET" could produce a messy answer; "SET TNS_ADMIN" might be a better choice on some systems.
Re: TNS_ADMIN [message #455722 is a reply to message #455719] Wed, 12 May 2010 12:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SET returns the parameters in alphabetical order not so messy (in the opposite of Unix "env" command).

Regards
Michel
Re: TNS_ADMIN [message #455737 is a reply to message #455722] Wed, 12 May 2010 13:22 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right.

However, my SET results are so ugly that mothers scare their children away with it.
Re: TNS_ADMIN [message #455884 is a reply to message #455737] Thu, 13 May 2010 04:50 Go to previous message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
/forum/fa/7378/0/


sriram Smile
Previous Topic: Oracle Data Provider for .NET 9.2.0.4.01 response file issues
Next Topic: database prob
Goto Forum:
  


Current Time: Thu Mar 28 15:49:36 CDT 2024