- Toad 188.8.131.52 64 bit
- Oracle 184.108.40.206 64 bit
- Windows 2008 and 2012 in the cloud. 64 bit.
My tnsnames.ora is in the usual place, oracle_home\network\admin. It consist of an IFILE command to pull in our central tnsnames.ora from a network share. I have the drive mapped as a specific drive as Oracle doesn’t work with \servermname\share type paths.
My own stuff goes here.
It seems that when I update the IFILE’d file, Toad doesn’t notice that this has happened and doesn’t refresh the list in the drop down. If I update my local file, it does, and the new entries appear.
I think we need a button to manually force a refresh of the tnsnames.ora, locally, so that we can pull in changes made in our IFILE’d files too.
I can change my local file from the tnsnames editor button on the New Session dialogue, which is fine, but it would be nice to be able to refresh the drop down from the dialogue itself.
Also, with my IFILE as listed above, running a syntax check in the tnsnames editor results in an error saying that the referenced file cannot be found.