执行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
-------------------------------------分割线-------------------------------------
推荐阅读:
ORA-01172、ORA-01151错误处理
ORA-00600 [2662]错误解决
ORA-01078 和 LRM-00109 报错解决方法
ORA-00471 处理方法笔记
ORA-00314,redolog 损坏,或丢失处理方法
ORA-00257 归档日志过大导致无法存储的解决办法
-------------------------------------分割线-------------------------------------
解决方法
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.
: