Oracle Database Appliance (ODA): Create table with HCC fails with ORA-64307 on ZFS storage appliance
(Doc ID 1464869.1)
Last updated on SEPTEMBER 25, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [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 188.8.131.52 to 184.108.40.206 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
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 220.127.116.11 with 13343438
o Verified that SNMP is active on ZFS.
snmpget -v1 -c public <IP for mount point> 18.104.22.168.22.214.171.124.126.96.36.199.0
SNMPv2-SMI::enterprises.188.8.131.52.4.2.0 = STRING: "Sun ZFS Storage 7320"
o Verified dNFS is configured bu querying v$dnfs_servers
o Tried to locatelibnetsnmp.so on the host running database instance.
# locate libnetsnmp.so
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!