ORA-15042: ASM disk "1" is missing from group number "1" in KVM guest.txt

Error:
ERROR: diskgroup DB_DATA was not mounted
ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "1" is missing from group number "1"



Solution:
Please perform the following checks in case if you are facing problem while mounting the disk group.
Check the Virt disk size and that should be same as the size of Physical disk provision from Host. Please rescan the iscsi bus in case if disk size mismatch.
o Get the Bus ID from multipath -ll output corresponding to the disk and run the below command for all ISCSI bus –
echo 1 > /sys/class/scsi_device/7\:0\:1\:22/device/rescan
echo 1 > /sys/class/scsi_device/7\:0\:3\:22/device/rescan
echo 1 > /sys/class/scsi_device/9\:0\:3\:22/device/rescan
echo 1 > /sys/class/scsi_device/9\:0\:1\:22/device/rescan
echo 1 > /sys/class/scsi_device/7\:0\:1\:2/device/rescan
echo 1 > /sys/class/scsi_device/7\:0\:3\:2/device/rescan
echo 1 > /sys/class/scsi_device/9\:0\:3\:2/device/rescan
echo 1 > /sys/class/scsi_device/9\:0\:1\:2/device/rescan
The Disk is mapped do a different device Name even after above given Procedure.

[root@DBServer ~]# ls -ltr /dev/disk/by-id/scsi-36*43
lrwxrwxrwx 1 root root 10 Oct  5 14:01 /dev/disk/by-id/scsi-36000d31000458a000000000000000143 -> ../../sdfl

36000d31000458a000000000000000054 dm-26 COMPELNT,Compellent Vol
size=10G features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 7:0:1:2  sdac 65:192  active ready running
  |- 9:0:1:2  sdbt 68:112  active ready running
  |- 7:0:3:2  sddv 71:208  active ready running
  `- 9:0:3:2  sdfl 130:112 active ready running


  36000d31000458a000000000000000143 dm-34 COMPELNT,Compellent Vol
size=1.0T features='1 queue_if_no_path' hwhandler='0' wp=rw
`-+- policy='round-robin 0' prio=1 status=active
  |- 7:0:1:22 sdas 66:192  active ready running
  |- 9:0:1:22 sdci 69:96   active ready running
  |- 7:0:3:22 sdel 128:208 active ready running
  `- 9:0:3:22 sdfv 131:16  active ready running

  So,  scsi-36000d31000458a000000000000000143 has to point to /sdfv. Now do a
  [root@DBServer ~]# udevadm trigger

After that Please check the output.

[root@DBServer ~]# ls -ltr /dev/disk/by-id/scsi-36*43
lrwxrwxrwx 1 root root 10 Dec 21 16:02 /dev/disk/by-id/scsi-36000d31000458a000000000000000143 -> ../../sdfv

Ensure that all Virt disk mapped on VM box belongs to correct disk group, for that please run the below command and check the diskgroup name.
o kfed read dev=/dev/vdb | grep -i grpname
If you find any disk which doesn’t belongs to DB diskgroup then please unmap and map the correct disk from VM console.

0 Comments