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.

1.
Verify that the ASM instance is up and running:
setenv ORACLE_SID +ASM
or use
export ORACLE_SID=+ASM
sqlplus "/as sysdba"
SQL> startup;
2.
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
or use
 export ORACLE_SID= Q0OR10G ...

Get Oracle® Database 10g Insider Solutions now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.