Multiple tnsnames.ora files

Toad for Oracle
1

Howdy,
My search fu is not working very well today. I did several searches and did not find an answer.

I work for a .gov agency. We have folks who remotely connect and use the various Oracle products as well as other products that connect to Oracle (TOAD being one).

What we are doing is instead of maintaining one master tnsnames.ora file (and putting up with the problems a corrupted one brings) is for each of us to have our own tnsnames.ora file.

The remote access installed version of TOAD points to the tnsnames.ora file that OEM etc point to.

Where can I go to change where TOAD points to the tnsnames.ora file?

I’ve been peeking/poking around but have not found that. I know about TNS_ADMIN, but if I remember correctly this info used to be part of TOAD also.

2

Where can I go to change where TOAD points to the tnsnames.ora file?

I’m not sure where to find it in the GUI, however it can be found in the
Toad.ini. I believe the value is “TNSLSMRUFilename”. You can confirm
by hovering over the TNS Names Editor button. It’ll provide you a path to
the file. Then you can search in your toad.ini for that path.

Roger S.

3

If you have a TNS_ADMIN folder defined, Toad will always use that one. If you
don’t have TNS_ADMIN defined, Toad will use the tnsnames.ora associated
with whatever Oracle Home you choose on Toad’s login screen.