如果asm磁盘发现路径中,既有udev方式创建的磁盘,又有asmlib创建的磁盘,那么,在asm_diskstring中,需要把两种情况都设置:
asm_diskstring string /dev/*, ORCL:*
否则,会报:
SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*';
alter system set asm_diskstring='/dev/oracleasm/disks/*'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-15014: path '/dev/asm-ocr1' is not in the discovery set
目前存在的磁盘:
1* select name,path from v$asm_disk
NAME PATH
------------------------------ --------------------
DATA_0000 /dev/asm-ocr1
DATA_0002 /dev/asm-ocr3
OGGDG_0000 /dev/asm-ogg01
DATA_0001 /dev/asm-ocr2
OGGDG_0001 /dev/asm-ogg02
DATADG_0000 /dev/asm-data
FRADG_0000 /dev/asm-fra
ASMLIB1 ORCL:ASMLIB1
网友评论