ASM创建磁盘组报错
SQL> create diskgroup dgroup1 normal redundancy failgroup fgroup1 disk 'ORCL:VOL1' failgroup fgroup2 disk 'ORCL:VOL2';
create diskgroup dgroup1 normal redundancy
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created
ORA-15031: disk specification 'ORCL:VOL2' matches no disks
ORA-15031: disk specification 'ORCL:VOL1' matches no disks
查看 v$asm_disk里为空。
解决方法:使用磁盘组绝对路径。
1:修改spfile参数
asm_diskstring='ORCL:VOL*' 修改为
asm_diskstring='/dev/oracleasm/disks/VOL*';
2:重启instance
3:使用绝对路径创建
SQL> create diskgroup dgroup1 normal redundancy failgroup fgroup1 disk '/dev/oracleasm/disks/VOL1' failgroup fgroup2 disk '/dev/oracleasm/disks/VOL2';
Diskgroup created.
SQL> select name from v$asm_diskgroup;
NAME
------------------------------
DGROUP1
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13561774/viewspace-714397/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13561774/viewspace-714397/