Toad is adding an equal sign after a comment 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 messed up.
Tnsnames shows in notepad:
xxxxxV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxxxxxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxxxxxxxxxxxxxxxxxxxxxx)
# (INSTANCE_NAME = xxxxxxV1)
)
)
Tnsname shows in Toad Tnsnames Editor:
xxxxxV1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxxxxxxxxxxxxxxxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxxxxxxxxxxxxxxxxxxxxxx)
)
)
# (INSTANCE_NAME = xxxxxxV1)
=
In Toad 10.6.1, this was working fine.
WORKAROUND:
None.
STATUS:
Issue fixed in version 12.0. Click here to download the latest version of Toad for Oracle.
