当前位置:Gxlcms > mysql > ORA-15031:diskspecification'/dev/oracleasm/disks/*'match

ORA-15031:diskspecification'/dev/oracleasm/disks/*'match

时间:2021-07-01 10:21:17 帮助过:94人阅读

执行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错误处理 http://www.linuxidc.com/Linux/2013-06/86529.htm

ORA-00600 [2662]错误解决 http://www.linuxidc.com/Linux/2013-06/86528.htm

ORA-01078 和 LRM-00109 报错解决方法 http://www.linuxidc.com/Linux/2012-07/66044.htm

ORA-00471 处理方法笔记 http://www.linuxidc.com/Linux/2013-09/90017.htm

ORA-00314,redolog 损坏,或丢失处理方法 http://www.linuxidc.com/Linux/2013-09/90646.htm

ORA-00257 归档日志过大导致无法存储的解决办法 http://www.linuxidc.com/Linux/2013-09/90594.htm

-------------------------------------分割线-------------------------------------

解决方法

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.

以上就是ORA-15031: disk specification '/dev/oracleasm/disks/*' match的内容,更多相关内容请关注PHP中文网(www.gxlcms.com)!

人气教程排行