How we can check if asm instance is being used by which db instance.

Post date: 22-May-2009 08:09:04

login to asm instance using sqlplus

            . setasm (Load the environment settings for asm, you can load manually as well if you do not have such scripts)

            sqlplus "/ as sysdba"

            select * from v$asm_client;