After installing Oracle Grid Infrastructure for a single instance, use the ASMCMD command-line utility to test the Oracle ASM installation.
- Use SQL*Plus to connect to the Oracle Automatic Storage Management instance as the
SYSASMprivilege and start the instance if necessary:
DRIVE_LETTER:\>sqlplus /nolog SQL> CONNECT SYS as SYSASM Enter password: SYS_password SQL> STARTUP
- 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;