This section discusses the common issues, challenges, and tips to overcome problems associated with setting up and using ASM for database storage.
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 ...