Sun Microsystems, Inc.  Oracle System Handbook - ISO 7.0 May 2018 Internal/Partner Edition
   Home | Current Systems | Former STK Products | EOL Systems | Components | General Info | Search | Feedback

Asset ID: 1-71-2162812.1
Update Date:2018-04-18
Keywords:

Solution Type  Technical Instruction Sure

Solution  2162812.1 :   FS System: Get ORA-15032, ORA-15242, ORA-15287 errors when enable HCC Compression On Flash Storage FS1  


Related Items
  • Oracle FS1-2 Flash Storage System
  •  
Related Categories
  • PLA-Support>Sun Systems>DISK>Flash Storage>SN-EStor: FSx
  •  




In this Document
Goal
Solution
References


Created from <SR 3-12872598291>

Applies to:

Oracle FS1-2 Flash Storage System - Version 6.1 to All Versions [Release 6.1 to All Releases]
Information in this document applies to any platform.

Goal

Enabling HCC compression on ASM disk group with partitions may fail with below error messages:

Trying to enable HCC compression on new Oracle Flash Storage FS1 on 12c database version. When setting attribute

alter diskgroup 'data_name' set attribute 'storage.type' = 'AXIOM'

receive the following error messages

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 '/dev/mapper/data_name' violates disk group attribute storage.type
Parameter compatible for ASM instance is 12.1.0.2.0

Solution

The errors are coming from the devices which has partitions.

ASM will have no problem working with partitions. But the SCSI query that brings back the vendor ID will not transferred correctly for partitions or when a file system has been created on devices.


The simple solution is:

  1. Create the same number and size of LUNs again.
  2. Discover the LUNs on the server (as the grid user or owner).
  3. Add the LUNs to ASM.
  4. Wait for the ASM background rebalance to complete.
  5. Delete the partitioned LUNs/ASM disks from ASM.
  6. Run the commands again.

References

<NOTE:1530772.1> - Pillar Axiom: How to Implement Oracle Hybrid Columnar Compression on Pillar Axiom SAN Storage
<NOTE:1547088.2> - How to Upload Files to Oracle Support
<NOTE:1943289.1> - FS System: How to Attach a Manual Log Bundle to an Existing MOS Service Request
<NOTE:2116491.1> - FS System: How to Enable Oracle Hybrid Columnar Compression (HCC) on the FS1-2
<NOTE:166650.1> - Working Effectively With Oracle Support - Best Practices
<BUG:23599356> - HCC COMPRESSION ERRORS ON 12C DATABASE VERSION WITH UNSUPPORTED PARTITIONED LUNS

Attachments
This solution has no attachment
  Copyright © 2018 Oracle, Inc.  All rights reserved.
 Feedback