ORA-15031: disk specification '/dev/oracleasm/disks/*' matches no disks

来源:互联网 发布:ni软件是什么 编辑:程序博客网 时间:2024/05/17 23:48

执行asmca创建磁盘组没有问题,但以sqlplus / as sysasm登陆创建却出现异常

SQL>create diskgroup DATA external redundancy disk '/dev/oracleasm/disks/*'

*
ERROR at line 1:
ORA-15018: diskgroup cannot be created

ORA-15031: disk specification '/dev/oracleasm/disks/*' matches no disks

解决方法

SQL> show parameter asm_diskstring;


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
asm_diskstring                       string


SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*' scope=spfile;


System altered.


[root@RAC1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop crs

[root@RAC1 ~]# /u01/app/11.2.0/grid/bin/crsctl start crs


SQL> create diskgroup DATA external redundancy disk '/dev/oracleasm/disks/*';


Diskgroup created.

0 0