OraFAQ Forum: Windows » TNS

Home » Infrastructure » Windows » TNS_ADMIN

Wed, 12 May 2010 10:45

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.

Wed, 12 May 2010 11:05

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

just execute:
set

Regards
Michel

Wed, 12 May 2010 12:28

Littlefoot
Messages: 21826
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.

Wed, 12 May 2010 12:42

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SET returns the parameters in alphabetical order not so messy (in the opposite of Unix "env" command).

Regards
Michel

Wed, 12 May 2010 13:22

Littlefoot
Messages: 21826
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.

Thu, 13 May 2010 04:50

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

sriram

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

Goto Forum:

]

Current Time: Thu Aug 06 21:19:50 CDT 2026