mismatch on 'Physical Sector Size' with target disk group [512] [4096]

<<Back to Oracle ASM Main Page
SQL> CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='4096', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created

ORA-15038: disk 'AFD:TEST07' mismatch on 'Physical Sector Size' with target disk group [512] [4096]

ORA-15038: disk 'AFD:TEST06' mismatch on 'Physical Sector Size' with target
disk group [512] [4096]

Let us check the Physical sector size of the disk

$ asmcmd afd_lsdsk
--------------------------------------------------------------------------------
Label                     Filtering   Path
================================================================================
TEST06                      ENABLED   /dev/xvdj6
TEST07                      ENABLED   /dev/xvdj7

# fdisk -l /dev/xvdj

Disk /dev/xvdj: 32.2 GB, 32212254720 bytes, 62914560 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk label type: dos
Disk identifier: 0xb87bb4b2

    Device Boot      Start         End      Blocks   Id  System
/dev/xvdj1            2048    62914559    31456256    5  Extended
/dev/xvdj5            4096    10489855     5242880   83  Linux
/dev/xvdj6        10491904    20977663     5242880   83  Linux
/dev/xvdj7        20979712    31465471     5242880   83  Linux
/dev/xvdj8        31467520    41953279     5242880   83  Linux
/dev/xvdj9        41955328    52441087     5242880   83  Linux

Solution: You can not create a diskgroup with Sector Size 4096 or 4K if the disk do not support the sector size and therefore specify the Sector Size 521 ( or that is supported by your system)

SQL> CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created

ORA-15238: 521 is not a valid value for attribute sector_size

Solution: The specified value for sector size is invalid accepted values are 512 , 4096 or 4k

SQL>CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='4096';
CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
*
ERROR at line 1:
ORA-15018: diskgroup cannot be created

ORA-15375: Physical sector size (512) cannot be smaller than the logical sector size (4096).

Solution: The physical sector size (SECTOR_SIZE) cannot be smaller than the logical sector
size (LOGICAL_SECTOR_SIZE) in an Oracle ASM disk group.

SQL>CREATE DISKGROUP TEST_DG NORMAL REDUNDANCY
FAILGROUP FG1 DISK
'AFD:TEST06'
FAILGROUP FG2 DISK
'AFD:TEST07'
ATTRIBUTE 'compatible.asm' = '12.2', 'compatible.rdbms' = '12.2',
'sector_size'='512', 'logical_sector_size'='512';
Diskgroup created.