Oracle Database Appliance (ODA): Create table with HCC fails with ORA-64307 on ZFS storage appliance
Last updated on MAY 26, 2014
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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 126.96.36.199 to 188.8.131.52 [Release 12.1]
Information in this document applies to any platform.
Trying to create a table with HCC in a tablespace created on ZFS storage failed
CREATE TABLE hcc_test
COMPRESS FOR QUERY HIGH
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 184.108.40.206 with 13343438
o Verified that SNMP is active on ZFS.
snmpget -v1 -c public <IP for mount point> 220.127.116.11.18.104.22.168.22.214.171.124.0
SNMPv2-SMI::enterprises.126.96.36.199.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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms