• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7845
  • Last Modified:

TOAD The environment for SQL*Net tnsnames

If I set TNS_ADMIN environment for windows START (right click computer) -> properties => advanced => environment variable ....
and then open a cmd session , and type "sqlplus ....", it  looks for tnsnames in TNS_ADMIN location

Is this true for TOAD database connections as well, if not how to force TOAD to look at a particular directory for tnsnames.ora
0
josephsonnd
Asked:
josephsonnd
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
GGuzdziolCommented:
TNS_ADMIN works for Toad as well.
0
 
Stephen LappinSenior TechnologistCommented:
Yes, TOAD uses TNSNAMES.ORA, and will use the TNS_ADMIN environment variable (if set).

With TOAD9, you can also use a direct connection, or use a connection stored in a LDAP directoy.

For a direct connection, you supply host, port (that listener is listening on) and either service name or SID.

0
 
SujithData ArchitectCommented:
You can make TOAD use the settings from Registry:

If you want to get the tnsnames.ora from another location in your machine other than the default location:

- In the TOAD connect window, see which oracle home you are using. You can see the dropdown list "Installed Clients"
 Say it is HOME<n>
- Open regedit>My Computer\ HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<n>
- add a string TNS_ADMIN, set the value of this string as your tnsnames.ora location
- save and close
- exit toad and launch again
- now you can see the entries from your tnsnames.ora in the connect window
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
josephsonndAuthor Commented:
Setting the TNS_ADMIN let TOAD7 use the tnsnames.ora in the location pointed to by TNS_ADMIN during connection. Work!

However, in the TOAD7 "connection window", when I click <TNSNames Editor>, then choose <file> tab, look at the tnsnames.ora file, it does not show the one at TNS_ADMIN, it shows the one at OH/network/admin
0
 
Stephen LappinSenior TechnologistCommented:
Do you have multiple Oracle Homes?
CAn you upgrade to TOAD 8.6 or TOAD 9.0?
0
 
SujithData ArchitectCommented:
Use the registry setting!
0
 
josephsonndAuthor Commented:
Talking to Management and in the process of getting upgrading to v9.0. Do you think it may be a bug in 7.6.0.11 ?

I do have multiple Oracle Homes, but I d have TNS_ADMIN set

As for registry setting , we do not let users modify their registry settings
0
 
josephsonndAuthor Commented:
sujiith80,

The company policy is that end-users not have access to modify their registry setting, although that is a good option

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now