在启动ASM的时候报错,报错如下:
SQL> startup
ASM instance started
Total System Global Area 130023424 bytes
Fixed Size 2019032 bytes
Variable Size 102838568 bytes
ASM Cache 25165824 bytes
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup
"ASM,KEL"
SQL> show parameter asm_disk
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
asm_diskgroups string ASM,KEL, KEL
asm_diskstring string ORCL:KEL*, ORCL:DATA, ORCL:OCR
SQL> alter system set asm_diskgroups='ASM,KEL' scope=both;
System altered.
SQL> show parameter asm_diskgroup;
NAME TYPE VALUE
------------------------------------ ---------- ------------------------------
asm_diskgroups string ASM,KEL
SQL> select name ,state from v$asm_diskgroup;
NAME STATE
---------- ----------------------
ASM DISMOUNTED
KEL MOUNTED
SQL> alter diskgroup asm mount;
Diskgroup altered.
SQL> select name,state from v$asm_diskgroup;
NAME STATE
---------- ----------------------
ASM MOUNTED
KEL MOUNTED
SQL> alter diskgroup all mount;
Diskgroup altered.
SQL> alter diskgroup all dismount;
Diskgroup altered
+ASM.asm_diskgroups='KEL','ASM'#Manual Mount
*.asm_diskgroups='ASM,KEL'
*.asm_diskstring='ORCL:KEL*','ORCL:DATA','ORCL:OCR_VOTE'