-->

DEVOPSZONES

  • Recent blogs

    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