Connect to ASM Instance Remotely

By Default Oracle ASM don’t allow remote sysdba connection since ASM instance is in NOMOUNT state. You Might get ORA-12528: TNS:listener: all appropriate instances are blocking new connections error when you are trying to connect ASM instance remotely. To bypass this error you need to add UR=A in the tns files like example below and connect as sysdba:



(ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))




(UR =A)