-->
  • Recent Articles

    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.

    No comments