How to connect to an ASM instance of Oracle with Toad?
Toad cannot connect to an ASM Oracle Instance directly like it does to other normal databases instances. Toad has a function called ASM Manager. It is located in the Database | Administer | ASM Manager. Use this to connect to ASM instances.
Your ASM Instance must be already set up and configured before using it with Toad.
When using ASM, the instance will start up as BLOCKED. You cannot UNBLOCK it, ASM is MOUNT only when started up by design. There are 2 ways to resolve this:
1. Modify listener.ora and add an ASM instance to it (static registration) this never work for me.
2. Add the lines below to tnsnames.ora. The (UR-A) is important, it allows connection to a BLOCKED instance.
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = +ASM)
For additional assistance setting up or configuring ASM, please contact Oracle support.
In case of “insufficient privileges” connection error, ensure a password file is in place in the ASM $ORACLE_HOME/dbs directory.In case of "ORA-01017: Invalid Username/password" connection error try the following in the Connect to ASM Instance window: In the 'database' dropdown type <'ip address>: