Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


TOAD The environment for SQL*Net tnsnames

Posted on 2006-11-12
Medium Priority
Last Modified: 2013-12-12
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
Question by:josephsonnd
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
  • +1
LVL 14

Assisted Solution

GGuzdziol earned 100 total points
ID: 17928616
TNS_ADMIN works for Toad as well.

Accepted Solution

Stephen Lappin earned 300 total points
ID: 17928696
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.

LVL 27

Assisted Solution

sujith80 earned 100 total points
ID: 17928815
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>
- 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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 17937921
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

Expert Comment

by:Stephen Lappin
ID: 17938677
Do you have multiple Oracle Homes?
CAn you upgrade to TOAD 8.6 or TOAD 9.0?
LVL 27

Expert Comment

ID: 17938748
Use the registry setting!

Author Comment

ID: 17939028
Talking to Management and in the process of getting upgrading to v9.0. Do you think it may be a bug in ?

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

Author Comment

ID: 17939044

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


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question