Getting ORA-15031 while creating the diskgroup and or adding disk to diskgroup.
The reason behind this is parameter asm_diskstring it should be set to ORCL:* or appropriate to your disk names.
For details below see below:
SQL> alter diskgroup FRA add disk '/dev/oracleasm/disks/ASM5';
alter diskgroup FRA add disk '/dev/oracleasm/disks/ASM5'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/oracleasm/disks/ASM5' matches no disks
ORA-15014: path '/dev/oracleasm/disks/ASM6' is not in the discovery set
SQL>
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string CRS
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
SQL>
SQL> alter system set asm_diskstring='ORCL:*';
System altered.
SQL> create diskgroup FRA external redundancy disk 'ORCL:ASM5';
Diskgroup created.
SQL> set lines 270 pages 10000
SQL> col diskgroup for a10
SQL> col DISKNAME for a30
SQL> select dg.NAME diskgroup, dg.TYPE, dg.VOTING_FILES,
2 ds.NAME diskname, ds.TOTAL_MB, ds.FREE_MB, dg.USABLE_FILE_MB
3 from V$ASM_DISKGROUP dg, V$asm_disk_stat ds
4 where dg.GROUP_NUMBER = ds.GROUP_NUMBER
5 order by diskgroup, diskname;
DISKGROUP TYPE V DISKNAME TOTAL_MB FREE_MB USABLE_FILE_MB
---------- ------ - ------------------------------ ---------- ---------- --------------
CRS EXTERN Y SYSCONF1 2047 1855 3739
CRS EXTERN Y SYSCONF2 2047 1884 3739
DATA EXTERN N ASM1 5114 4568 25600
DATA EXTERN N ASM2 5114 4567 25600
DATA EXTERN N ASM3 5114 4570 25600
DATA EXTERN N ASM4 5114 4570 25600
DATA EXTERN N ASM7 8189 7325 25600
FRA EXTERN N ASM5 5114 5064 5064
8 rows selected.
SQL>
SQL> alter diskgroup FRA add disk 'ORCL:ASM8';
Diskgroup altered.
SQL> set lines 270 pages 10000
SQL> col diskgroup for a10
SQL> col DISKNAME for a30
SQL> select dg.NAME diskgroup, dg.TYPE, dg.VOTING_FILES,
2 ds.NAME diskname, ds.TOTAL_MB, ds.FREE_MB, dg.USABLE_FILE_MB
3 from V$ASM_DISKGROUP dg, V$asm_disk_stat ds
4 where dg.GROUP_NUMBER = ds.GROUP_NUMBER
5 order by diskgroup, diskname;
DISKGROUP TYPE V DISKNAME TOTAL_MB FREE_MB USABLE_FILE_MB
---------- ------ - ------------------------------ ---------- ---------- --------------
CRS EXTERN Y SYSCONF1 2047 1855 3739
CRS EXTERN Y SYSCONF2 2047 1884 3739
DATA EXTERN N ASM1 5114 4568 25600
DATA EXTERN N ASM2 5114 4567 25600
DATA EXTERN N ASM3 5114 4570 25600
DATA EXTERN N ASM4 5114 4570 25600
DATA EXTERN N ASM7 8189 7325 25600
FRA EXTERN N ASM5 5114 5065 13251
FRA EXTERN N ASM8 8189 8186 13251
9 rows selected.
SQL>
The reason behind this is parameter asm_diskstring it should be set to ORCL:* or appropriate to your disk names.
For details below see below:
SQL> alter diskgroup FRA add disk '/dev/oracleasm/disks/ASM5';
alter diskgroup FRA add disk '/dev/oracleasm/disks/ASM5'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/oracleasm/disks/ASM5' matches no disks
ORA-15014: path '/dev/oracleasm/disks/ASM6' is not in the discovery set
SQL>
SQL> show parameter asm
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
asm_diskgroups string CRS
asm_diskstring string
asm_power_limit integer 1
asm_preferred_read_failure_groups string
SQL>
SQL> alter system set asm_diskstring='ORCL:*';
System altered.
SQL> create diskgroup FRA external redundancy disk 'ORCL:ASM5';
Diskgroup created.
SQL> set lines 270 pages 10000
SQL> col diskgroup for a10
SQL> col DISKNAME for a30
SQL> select dg.NAME diskgroup, dg.TYPE, dg.VOTING_FILES,
2 ds.NAME diskname, ds.TOTAL_MB, ds.FREE_MB, dg.USABLE_FILE_MB
3 from V$ASM_DISKGROUP dg, V$asm_disk_stat ds
4 where dg.GROUP_NUMBER = ds.GROUP_NUMBER
5 order by diskgroup, diskname;
DISKGROUP TYPE V DISKNAME TOTAL_MB FREE_MB USABLE_FILE_MB
---------- ------ - ------------------------------ ---------- ---------- --------------
CRS EXTERN Y SYSCONF1 2047 1855 3739
CRS EXTERN Y SYSCONF2 2047 1884 3739
DATA EXTERN N ASM1 5114 4568 25600
DATA EXTERN N ASM2 5114 4567 25600
DATA EXTERN N ASM3 5114 4570 25600
DATA EXTERN N ASM4 5114 4570 25600
DATA EXTERN N ASM7 8189 7325 25600
FRA EXTERN N ASM5 5114 5064 5064
8 rows selected.
SQL>
SQL> alter diskgroup FRA add disk 'ORCL:ASM8';
Diskgroup altered.
SQL> set lines 270 pages 10000
SQL> col diskgroup for a10
SQL> col DISKNAME for a30
SQL> select dg.NAME diskgroup, dg.TYPE, dg.VOTING_FILES,
2 ds.NAME diskname, ds.TOTAL_MB, ds.FREE_MB, dg.USABLE_FILE_MB
3 from V$ASM_DISKGROUP dg, V$asm_disk_stat ds
4 where dg.GROUP_NUMBER = ds.GROUP_NUMBER
5 order by diskgroup, diskname;
DISKGROUP TYPE V DISKNAME TOTAL_MB FREE_MB USABLE_FILE_MB
---------- ------ - ------------------------------ ---------- ---------- --------------
CRS EXTERN Y SYSCONF1 2047 1855 3739
CRS EXTERN Y SYSCONF2 2047 1884 3739
DATA EXTERN N ASM1 5114 4568 25600
DATA EXTERN N ASM2 5114 4567 25600
DATA EXTERN N ASM3 5114 4570 25600
DATA EXTERN N ASM4 5114 4570 25600
DATA EXTERN N ASM7 8189 7325 25600
FRA EXTERN N ASM5 5114 5065 13251
FRA EXTERN N ASM8 8189 8186 13251
9 rows selected.
SQL>
No comments:
Post a Comment