ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASM,KEL"
在启动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"
得知是ASM参数文件中的参数asm_diskgroup配置错误,查看如下:
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'
配置文件里的配置,注意第一个的配置,必须将两个分开写,不然的话,在下次启动的时候还是报错。
for linux and python