Accessing objects on HCC tablespace on ZFS throws ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

Asset ID:	1-72-1962513.1
Update Date:	2015-05-07
Keywords:

Solution Type Problem Resolution Sure

Solution 1962513.1 : Accessing objects on HCC tablespace on ZFS throws ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

Applies to:

Sun ZFS Storage 7420 - Version All Versions and later
Information in this document applies to any platform.

Symptoms

HCC can be enabled for Oracle Databases residing in ASM on iSCSI or Fibre Channel LUNs, or dNFS shares, on a
ZFS Storage Appliance beginning with Oracle Database 11g, Enterprise Edition on 11.2.0.4.

Customer created HCC tablespace on ZFS on Oracle Database 11.2.0.4. When access objects on HCC tablespace, database throws error
ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type

Cause

To find out why it throws ORA-64307, enable ORA-64309 errorstack.
SQL> alter system set events '64307 trace name errorstack level 3';

Trace file shows that it hit this error when creating an index.

ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type
----- Current SQL Statement for this session (sql_id=57sw6y5bw5nhq) -----
CREATE UNIQUE INDEX ...
----- Call Stack Trace -----
dbkdaKsdActDriver dbgdaExecuteAction dbgdaRunAction dbgdRunActions dbgdProcessEventAct dbgdChkEventKgErr dbkdChkEventRdbmsEr ksfpec dbgePostErrorKGE dbkePostKGE_kgsf kgeselv ksesecl0 kdsGetFullDecompressedImage kdstgr

It hit Bug 17648596 - CANNOT QUERY HCC COMPRESSED TABLE STORED ON ZFS 7420, fixed in Exadata BP11.2.0.4.8, and included in 11.2.0.4.3DBPSU for non-Exadata database.

Solution

Apply patch 17648596, or upgrade to Exadata BP11.2.0.4.8, or 11.2.0.4.3DBPSU for non-Exadata database.

References

<NOTE:1929374.1> - Exadata: HCC (Hybrid Columnar Compression) Does Not Work On ZFS File System
<NOTE:17648596.8> - Bug 17648596 - ORA-64307 from query on Hcc Compressed Table Stored On ZFS 7420
<BUG:17648596> - CANNOT QUERY HCC COMPRESSED TABLE STORED ON ZFS 7420
<NOTE:1452614.1> - How To Setup DNFS (Direct NFS) On Oracle Release 11.2
<NOTE:12979161.8> - Bug 12979161 - dNFS needs to support SNMP calls over management interface
<NOTE:166650.1> - Working Effectively With Oracle Support - Best Practices

Attachments

This solution has no attachment