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)
)
)
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center