Solved

TOAD The environment for SQL*Net tnsnames

Posted on 2006-11-12
8
7,739 Views
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
0
Comment
Question by:josephsonnd
  • 3
  • 2
  • 2
  • +1
8 Comments
 
LVL 14

Assisted Solution

by:GGuzdziol
GGuzdziol earned 25 total points
Comment Utility
TNS_ADMIN works for Toad as well.
0
 
LVL 7

Accepted Solution

by:
lappins earned 75 total points
Comment Utility
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
 
LVL 27

Assisted Solution

by:sujith80
sujith80 earned 25 total points
Comment Utility
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
 

Author Comment

by:josephsonnd
Comment Utility
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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 7

Expert Comment

by:lappins
Comment Utility
Do you have multiple Oracle Homes?
CAn you upgrade to TOAD 8.6 or TOAD 9.0?
0
 
LVL 27

Expert Comment

by:sujith80
Comment Utility
Use the registry setting!
0
 

Author Comment

by:josephsonnd
Comment Utility
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
 

Author Comment

by:josephsonnd
Comment Utility
sujiith80,

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

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
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 recover a database from a user managed backup

762 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now