When you add disks to the ASM Disk group, you can get ” ORA-15032 ORA-15031 ORA-15025 ORA-27041 ” errors.
Details of error are as follows.
ALTER DISKGROUP DATA ADD DISK '/dev/oracleasm/disks/ASMDATA08' NAME ASMDATA08 SIZE 512G REBALANCE POWER 10; ORA-15032: not all alterations performed ORA-15031: disk specification '/dev/oracleasm/disks/ASMDATA08' matches no disks ORA-15025: could not open disk "/dev/oracleasm/disks/ASMDATA08" ORA-27041: unable to open file Linux-x86_64 Error: 13: Permission denied Additional information: 42
To solve this problem, you need to alter asm_diskstring parameter as follows.
alter system set asm_diskstring = '/dev/oracleasm/disks/*' SID='*' scope=both; SQL> alter system set asm_diskstring = '/dev/oracleasm/disks/ASMDATA*' SID='*' scope=both; alter system set asm_diskstring = '/dev/oracleasm/disks' SID='*' scope=both * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-15014: path 'ORCL:ASMDATA06' is not in the discovery set
If you got also above errors.
Modify it into SPFile then restart Database and CRS.
SQL> alter system set asm_diskstring = '/dev/oracleasm/disks/ASMDATA*' SID='*' scope=spfile;
Once you restarted CRS and Database, you can try it again.
SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ASMDATA08'; Diskgroup altered. SQL> alter diskgroup DATA add disk '/dev/oracleasm/disks/ASMDATA09'; Diskgroup altered. SQL>
Do you want to learn more detail about Oracle ASM ? Read the following article.
70 views today, 3 views in last 3 hour