Testing the Oracle Automatic Storage Management Installation

After installing Oracle Grid Infrastructure for a single instance, use the ASMCMD command-line utility to test the Oracle ASM installation.

1. Use SQL*Plus to connect to the Oracle Automatic Storage Management instance as the SYS user with SYSASM privilege and start the instance if necessary:

   DRIVE_LETTER:\>sqlplus /nolog
   SQL> CONNECT SYS as SYSASM
   Enter password: SYS_password 
   SQL> STARTUP
   

2. Enter the following command to view the existing disk groups, their redundancy level, and the amount of free disk space in each one:

   SQL> SELECT NAME,TYPE,TOTAL_MB,FREE_MB FROM V$ASM_DISKGROUP;