TOAD does not recognize entries in the TNSNAMES.ora file. This can be verified by using the tnsnames editor option in TOAD under the TEXT Editor tab. Formatting gets disrupted and TNS entries get altered.
Tnsnames.ora shown in notepad:
xxxxx.world, dev1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(COMMUNITY = xxxxx.world)(PROTOCOL = TCP)(Host = xxxxx)(Port = 1528)))(CONNECT_DATA =(SID = dev1)(GLOBAL_NAME = xxxxx.world)))
xxxxx.world, dsn1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(COMMUNITY = xxxxxxx)(PROTOCOL = TCP)(Host = devdb1)(Port = 1529)))(CONNECT_DATA =(SID = dsn1)(GLOBAL_NAME = xxxxx.world)))
Tnsnames.ora shown in Toad Tnsnames Editor:
xxxxx.world, dev1 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(COMMUNITY = xxxxx.world)(PROTOCOL = TCP)(Host = xxxxx)(Port = 1528)))(CONNECT_DATA =(SID = dev1)(GLOBAL_NAME = xxxxx.world)))
(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(COMMUNITY = xxxxxxx)(PROTOCOL = TCP)(Host = devdb1)(Port = 1529)))(CONNECT_DATA =(SID = dsn1)(GLOBAL_NAME = xxxxx.world)))
In Toad 10.6.1, this works fine.
WORKAROUND
None
STATUS
Issue fixed in version 12.0.
The latest version of Toad for Oracle can be downloaded at the Quest Software Support Portal.
