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

Asset ID:	1-72-1464869.1
Update Date:	2012-10-09
Keywords:

Solution Type Problem Resolution Sure

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

Applies to:

Oracle Server - 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
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

Unpublished Bug 12979161 - DNFS NEEDS TO SUPPORT SNMP CALLS OVER MANAGEMENT INTERFACE

dNFS looks for the libnetsnmp.so library to issue SNMP queries to identify ZFSSA. In some kernels, the library is named libnetsnmp.so.10 instead of libnetsnmp.so.

Solution

The workaround is to:

1. Create a softlink as follows ,on every database host

cd /usr/lib64/
ln -s libnetsnmp.so.10.0.3 libnetsnmp.so

2. Restart all the database instances

A permanent fix for the bug is included in 11.2.0.4 patchset and version 12.1 (see <Note 12979161.8>)

References

<BUG:14083099> - HCC DOES NOT WORK ZFS CONNECTED TO ODA
<NOTE:1463638.1> - Oracle Database Appliance FAQ
<NOTE:1354980.1> - Sun Storage 7000 Unified Storage System: FAQ: RMAN backup from Exadata to Sun ZFS Backup Appliance
<NOTE:762374.1> - Step by Step - Configure Direct NFS Client (DNFS) on Linux (11g)
<NOTE:12979161.8> - Bug 12979161 - dNFS needs to support SNMP calls over management interface

Attachments

This solution has no attachment