Upon connection, customer receives "ORA-12528: TNS:listener: all appropriate instances are blocking new connections" when trying to connect to a RAC environment with the ASM option checkbox checked.
From the tnsnames.ora file, it can be two causes:
1. option (UR = A) for the Spotlight connection must be included
2. SID is used rather than SERVICE_NAME
Open then tnsnames.ora file on client PC and verify if the below format is followed:
ASM_CONNECT=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <host>)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM1)
(INSTANCE_NAME = +ASM1)
(UR=A)
)
)
