When tried to create diskgroup FRA, and got errors as below:
SQL> CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/ASM_FRA01' NAME ASM_FRA01; CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/ASM_FRA01' NAME ASM_FRA01 * ERROR at line 1: ORA-15018: diskgroup cannot be created ORA-15031: disk specification '/dev/oracleasm/disks/ASM_FRA01' matches no disks ORA-15014: path '/dev/oracleasm/disks/ASM_FRA01' is not in the discovery set
Checked ASM disk already existed:
# oracleasm listdisks ... ... ASM_FRA01 OCR_VOTE01 ... ... SQL> ! ls -ltr /dev/oracleasm/disks/ASM_FRA01 brw-rw---- 1 grid dba 253, 2 Sep 26 15:32 /dev/oracleasm/disks/ASM_FRA01
Checked parameter asm_diskstring empty:
SQL> show parameter string NAME TYPE VALUE ---------------- --------- ----- asm_diskstring string
Could not change parameter asm_diskstring=’/dev/oracleasm/disks/*’
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 'ORCL:OCR_VOTE01' is not in the discovery set
Change parameter asm_diskstring=’/dev/oracleasm/disks/*’ in spfile only :
SQL> alter system set asm_diskstring='/dev/oracleasm/disks/*' scope=spfile; System altered.
Stop and then start CRS again :
# /u01/app/12.1.0.2/grid/bin/crsctl stop crs ... ... ... # /u01/app/12.1.0.2/grid/bin/crsctl start crs
Check current parameter asm_diskstring :
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string
asm_diskstring string /dev/oracleasm/disks/*
asm_power_limit integer 10
asm_preferred_read_failure_groups string
Check disks path :
SQL> col PATH format a60 SQL> select NAME,LABEL,PATH from v$asm_disk; NAME LABEL PATH ------------------------------ ------------------------------- ------------------------------------------------------------ /dev/oracleasm/disks/ASM_disk09 /dev/oracleasm/disks/ASM_DISK05 /dev/oracleasm/disks/ASM_DISK08 /dev/oracleasm/disks/ASM_DISK01 /dev/oracleasm/disks/ASM_DISK06 /dev/oracleasm/disks/ASM_DISK07 /dev/oracleasm/disks/ASM_FRA01 /dev/oracleasm/disks/ASM_DISK04 /dev/oracleasm/disks/ASM_DISK02 /dev/oracleasm/disks/ASM_DISK03 OCR_VOTE01 /dev/oracleasm/disks/OCR_VOTE01 11 rows selected.
Now create diskgroup FRA successfully :
SQL> CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK '/dev/oracleasm/disks/ASM_FRA01' NAME ASM_FRA01; Diskgroup created.
There is another way to add disks or cerate diskgroup and does not require to restart GRID:
ALTER DISKGROUP ADD DISK ‘ORCL:>DISK NAME WITHOUT PATH> ;
ie:
CREATE DISKGROUP FRA EXTERNAL REDUNDANCY DISK ‘ORCL:FRA01’ NAME ASM_FRA01;
LikeLiked by 1 person