Today we have looked over ASM Instance Remotely. We can see that the normal instance of RDBMS is different from ASM. Connect to ASM Instance Remotely Being DBA we are aware that 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 the example below and connect as sysdba:

ASM_Remote =


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




(UR =A)



Today’s thought…..

The power of imagination makes us infinite. —John Muir

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel :

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp



About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.