Avoiding ASM Pitfalls
This section discusses the common issues, challenges, and tips to overcome problems associated with setting up and using ASM for database storage.
Unable to Connect to ASM Instance
If you get errors like ORA-17203 or ORA-15055 when trying to connect from a database instance to an ASM instance, follow these steps to check and fix the error conditions.
Verify that the ASM instance is up and running:
setenv ORACLE_SID +ASM
export ORACLE_SID=+ASM sqlplus "/as sysdba" SQL> startup;
When the ASM instance starts up, export your session to point to the ORACLE_HOME of the database you had problems with. Follow the same steps as in the ASM instance:
setenv ORACLE_SID = Q0OR10G
export ORACLE_SID= Q0OR10G ...