Oracle Database Appliance (ODA): Create table with HCC fails with ORA-64307 on ZFS storage appliance (Doc ID 1464869.1)

Last updated on MAY 26, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Sun ZFS Storage 7320 - Version Not Applicable to Not Applicable [Release N/A]
Oracle Database Appliance - Version All Versions and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Trying to create a table with HCC in a tablespace created on ZFS storage failed

CREATE TABLE hcc_test
COMPRESS FOR QUERY HIGH
TABLESPACE hcc_tb_space
AS
SELECT owner, table_name, column_name FROM dba_tab_columns;

ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type

o Verified that the customer is on 11.2.0.3 with 13343438

o Verified that SNMP is active on ZFS.
snmpget -v1 -c public <IP for mount point> 1.3.6.1.4.1.42.2.225.1.4.2.0

SNMPv2-SMI::enterprises.42.2.225.1.4.2.0 = STRING: "Sun ZFS Storage 7320"

o Verified dNFS is configured bu querying v$dnfs_servers

o Tried to locate libnetsnmp.so on the host running database instance.

# locate libnetsnmp.so
/usr/lib64/libnetsnmp.so.10
/usr/lib64/libnetsnmp.so.10.0.3

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms