Site icon IT Tutorial

ORA-15032: not all alterations performed ORA-15031 ORA-15025 ORA-27041 ORA-15014 | Add Disks to ASM Disk Group in Oracle

Hi,

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.

https://ittutorial.org/oracle-automatic-storage-management-2-asm/

Exit mobile version