ORA-15032: not all alterations performed in Oracle ASM !!

by

The ORA-15032 error in Oracle is related to issues with the disk groups and ASM.

This error indicates that some of the requested alterations to the disk group could not be completed. The reasons for this error can vary, but it often involves problems with disk group configurations, permissions, or the state of the ASM instance.

Possible Causes:

1. The disk group may not be mounted.
2. Insufficient privileges to perform the operation.
3. An attempt to perform an unsupported operation.
4. Issues with the disk group configuration.

Solution:

1. Check list disks.
1
2
3
4
5
6
7
SQL> ALTER DISKGROUP DATA MOUNT;
ALTER DISKGROUP DATA MOUNT
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15017: diskgroup "DATA" cannot be mounted
ORA-15040: diskgroup is incomplete

Ensure that the disk group is mounted and available.

1
2
3
SELECT NAME, STATE FROM V$ASM_DISKGROUP;
 
ps -ef | grep asm

Check Disk Group Status:

1
2
3
SET LINESIZE 200
COL NAME FOR A20
SELECT NAME, STATE FROM V$ASM_DISKGROUP;

Mount Disk Group (if necessary):

1
ALTER DISKGROUP <diskgroup_name> MOUNT;

Or you can verify below steps and make some changes to resolve this ORA error.

2. Comment sd parameter

root@localhost01: grep -i sd /etc/sysconfig/oracleasm
1
2
3
4
ORACLEASM_SCANEXCLUDE="sd"
-- comment ORACLEASM_SCANEXCLUDE="sd" from /etc/sysconfig/oracleasm
root@localhost01:/root
23:40:22 # oracleasm listdisks

3. Scandisk

1
2
3
4
5
6
7
8
root@localhost01:
23:41:34 # oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks…
Scanning system for ASM disks…
Instantiating disk "PDTVD_ASMDISK001"
Instantiating disk "PDTVD_ASMDISK002"
Instantiating disk "PDTVD_ASMDISK003"

4. List disks

1
2
3
4
5
root@localhost01:
23:41:40 # oracleasm listdisks
PDTVD_ASMDISK001
PDTVD_ASMDISK002
PDTVD_ASMDISK003

5. Stop ASM & Start ASM

1
2
3
4
5
6
7
root@localhost01:
export GRID_HOME=/u01/grid/oracle/product/19/grid
$GRID_HOME/bin/crsctl stop crs
 
root@localhost01:
export GRID_HOME=/u01/grid/oracle/product/19/grid
$GRID_HOME/bin/crsctl start crs

Hope it helped !! 🙂