ORA-15032,ORA-15031,ORA-15014

来源：互联网发布：mac windows 7 iso 编辑：程序博客网时间：2024/05/17 23:27

数据库环境：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

果然增加成功了

0 0