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'

配置文件里的配置，注意第一个的配置，必须将两个分开写，不然的话，在下次启动的时候还是报错。

巴特西

ORA-15063: ASM discovered an insufficient number of disks for diskgroup "ASM,KEL"

最新文章

热门文章