Toad for Oracle Xpert 11.6.0.43. We have multiple ASM instances. In the Toad login screen, in the Database drop down, only the first ASM instance in the TNSNAMES shows up? The other two does not show. I can manually type it in and it works.
For example, in the ASM instances below, only the first one appears in the DB drop-down list.
CMA_CP_+ASM.gpdb001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP )(HOST = abcdb001)(PORT = 1562))
(CONNECT_DATA =
(SID = +ASM)
(SERVER = DEDICATED)
)
)
CMA_CP_+ASM.gpdb002 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP )(HOST = abcdb002)(PORT = 1562))
(CONNECT_DATA =
(SID = +ASM)
(SERVER = DEDICATED)
)
)
CMA_CP_+ASM.gpdb003 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP )(HOST = abcdb003)(PORT = 1562))
(CONNECT_DATA =
(SID = +ASM)
(SERVER = DEDICATED)
)
)
WORKAROUND:
Manually type the ASM instance and you should still be able to connect.
STATUS:
Waiting for fix in a future release of Toad for Oracle.
