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 184.108.40.206 to 220.127.116.11 [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 18.104.22.168 to 22.214.171.124 [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 126.96.36.199 with 13343438
o Verified that SNMP is active on ZFS.
snmpget -v1 -c public <IP for mount point> 188.8.131.52.184.108.40.206.220.127.116.11.0
SNMPv2-SMI::enterprises.18.104.22.168.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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms