数据库环境：ORACLE 11G RAC环境
操作系统：linux
今天想添加个ASM磁盘，在alter diskgroup的时候数据库报错
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/CRS_DISK05' rebalance power 5;
alter diskgroup DATA add disk '/dev/oracleasm/disks/CRS_DISK05' rebalance power 5
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/oracleasm/disks/CRS_DISK05' matches no
disks
ORA-15014: path '/dev/oracleasm/disks/CRS_DISK05' is not in the discovery set
遇到此问题第一想法就是去检查磁盘路径和权限
[root@rac3 ~]# ll /dev/oracleasm/disks/
总用量 0
brw-rw---- 1 grid asmadmin 8, 49 7月 9 23:04 CRS_DISK01
brw-rw---- 1 grid asmadmin 8, 81 7月 9 23:04 CRS_DISK02
brw-rw---- 1 grid asmadmin 8, 65 7月 9 23:04 CRS_DISK03
brw-rw---- 1 grid asmadmin 8, 97 7月 9 23:04 CRS_DISK04
brw-rw---- 1 grid asmadmin 8, 17 7月 9 23:14 CRS_DISK05
经过判断磁盘路径和磁盘权限都正常
然后经过三哥指导
SQL> show parameter asm_diskstring;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring string
原来是这个参数问题，尝试修改参数
SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*' scope=spfile;
System altered.
然后再次尝试添加磁盘
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/CRS_DISK05' rebalance power 5;
Diskgroup altered.
提示成功，验证磁盘大小
SQL> select name,total_mb,free_mb from v$asm_diskgroup;
NAME TOTAL_MB FREE_MB
------------------------------ ---------- ----------
DATA0 102398 97660
DATA 92157 63552
果然增加成功了