O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required