ORA-15032: not all alterations performed in Oracle ASM !!
2 min readThe 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.
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.
SELECT NAME, STATE FROM V$ASM_DISKGROUP;
ps -ef | grep asm
Check Disk Group Status:
SET LINESIZE 200
COL NAME FOR A20
SELECT NAME, STATE FROM V$ASM_DISKGROUP;
Mount Disk Group (if necessary):
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
ORACLEASM_SCANEXCLUDE="sd"
-- comment ORACLEASM_SCANEXCLUDE="sd" from /etc/sysconfig/oracleasm
root@localhost01:/root
23:40:22 # oracleasm listdisks
3. Scandisk
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
root@localhost01:
23:41:40 # oracleasm listdisks
PDTVD_ASMDISK001
PDTVD_ASMDISK002
PDTVD_ASMDISK003
5. Stop ASM & Start ASM
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 !! 🙂
