My Oracle Support Banner

Setting the storage.type to 'AXIOM' or 'ZFSSA' fails with ORA-15285 (Doc ID 1555608.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 18.1.0.0.0 [Release 11.2 to 18]
Linux x86-64

Symptoms

To enable Hybrid Columnar Compression(HCC) on AXIOM pillar storage, we need to set the storage.type attribute to AXIOM, and this could fail with ORA-15285

 

SQL> alter diskgroup DATA_DM01 set attribute 'storage.type'='AXIOM';
alter diskgroup DATA_DM01 set attribute 'storage.type'='AXIOM'

ORA-15032: not all alterations performed
ORA-15242: could not set attribute storage.type
ORA-15287: could not set disk group attribute storage.type due to incompatible disks
ORA-15285: disk '/dev/oracleasm/disks/DISK1' violates disk group attribute storage.type

To enable Hybrid Columnar Compression(HCC) on ZFS storage, we need to set the storage.type attribute to ZFSSA, and this could fail with ORA-15285

SQL> alter diskgroup DATA set attribute 'storage.type'='ZFSSA';
alter diskgroup DATA set attribute 'storage.type'='ZFSSA'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15242: could not set attribute storage.type
ORA-15287: could not set disk group attribute storage.type due to incompatible disks
ORA-15285: disk 'AFD:DATA1' violates disk group attribute storage.type

Changes

Diskgroup DATA contain only one non partitioned disk

fdisk -l
Disk /dev/mapper/mpathb: 107.4 GB, 107374182400 bytes, 209715200 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 8192 bytes / 8192 bytes

The device is multipathed which is supported
Query on the device correctly provides ZFS level

[grid]#  sg_inq /dev/mapper/mpathb
standard INQUIRY:
PQual=0  Device_type=0  RMB=0  version=0x05  [SPC-3]
[AERC=0]  [TrmTsk=0]  NormACA=1  HiSUP=1  Resp_data_format=2
SCCS=0  ACC=0  TPGS=1  3PC=0  Protect=0  [BQue=0]
EncServ=0  MultiP=0  [MChngr=0]  [ACKREQQ=0]  Addr16=0
[RelAdr=0]  WBus16=0  Sync=0  Linked=0  [TranDis=0]  CmdQue=1
[SPI: Clocking=0x0  QAS=0  IUS=0]
  length=74 (0x4a)   Peripheral device type: disk
Vendor identification: SUN
Product identification: ZFS Storage 7350
Product revision level: 1.0
Unit serial number:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.