John’s reply about an IFILE command causing the included tnsnames
aliases to be included in the drop down was interesting, as I’ve never
seen it happen! Usually, when at work (in my last contract) I had a
local tnsnames with two IFILE directives, one to pull in the standard
tnsnames frile, and one to pull in my own, or test stuff. None appeared
in the drop down, only anything hard coded into the local tnsnames.ora.
I know that this was also the case quite recently for version 12 as I
used that to perform a technical review of Bert & Dan’s "Toad for Oracle
Unleashed" book that has recently hist the shops. So, I’ll need to go
off and play a bit to see if it all “just” works now.
Ok, in version 18.104.22.168, I am unable to see anything outside the
tnsnames.ora file for my default oracle home (the only home on my
laptop) but I can connect to any alias I have set up in the included IFILE.
Perhaps it is Chris’ version of Toad that is causing the entries in the
IFILE(s) not to be included in the drop down? Or John has a much more up
to date Toad than we have? Just a thought.
What I eventually did with my own system - back in my last contract -
was to take the various tnsnames files, and pass them through a
converter that I wrote (sadly, in Java!) which allows me to import the
connections into my connection grid as per the new session dialogue.
If anyone wants to play with this, it’s at
If you wish, there’s also a tnsnames validator utility at
which carries out syntax and semantic validations on your tnsnames file(s).
These are both free, source is available, and might be useful, perhaps,