Oracle ASM reporting disk "string" is truncated for SAN attached emcpower disk

Solution Verified - Updated -

Environment

Red Hat Enterprise Linux (RHEL) 5u5

Oracle ASM

Issue

  • When trying to start a Oracle database the error is seen:

    PRCR-1079 : Failed to start resource ora.h01rpt.db
CRS-5017: The resource action "ora.DATA.dg start" encountered the following error:
ORA-15032: not all alterations performed
ORA-15036: disk 'ORCL:DISK_XXX' is truncated

  • Another error seen:

    ORA-15036: disk "string" is truncated 
Cause: The size of the disk, as reported by the operating system, was smaller than  
the size of the disk as recorded in the disk header block on the disk.  
Action: Check if the system configuration has changed.

Resolution

Restored the disk partition and data from a known back using dd.  Recommendation would be to avoid using the Oracle ASM GUI for creating ASM disks and use the CLI only.

Root Cause

This may be an issue/bug with the Oracle ASM GUI tool, since the disk  ASM reported the error on was created using the GUI.  There were two  other LUNs presented, but the DBA used the CLI, and there were not  issue(s) with the two other LUNs.  When created using the GUI the disk geometry stored within Oracle ASM differed by 2 MB compared to what sfdisk and fdisk reported.

Diagnostic Steps

  • Look at output from sfdisk for the underlying emcpowerX device that ASM is reporting the error on:

    $ sudo sfdisk -uB -l /dev/emcpowerx
Disk /dev/emcpowerx: 16709 cylinders, 255 heads, 63 sectors/track
Units = blocks of 1024 bytes, counting from 0

   Device Boot   Start       End    #blocks   Id  System
/dev/emcpowerx1           64  134215042- 134214978+  83  Linux
          start: (c,h,s) expected (0,2,3) found (0,1,1)   # what is this? <===
/dev/emcpowerx2            0         -          0    0  Empty
/dev/emcpowerx3            0         -          0    0  Empty
/dev/emcpowerx4            0         -          0    0  Empty

  • Consider fdisk output for the same disk

    $ sudo fdisk  -l /dev/emcpowerx

Disk /dev/emcpowerx: 137.4 GB, 137438953472 bytes
255 heads, 63 sectors/track, 16709 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

         Device Boot      Start         End      Blocks   Id  System
/dev/emcpowerx1               1       16709   134214978+  83  Linux
  • Component
  • acl

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments