Home > HCC (Hybrid Columnar Compression), ZFS Storage Appliance > How To Enable HCC (Hybrid Columnar Compression) in Oracle Databases Running On ZFS Storage Appliance?

How To Enable HCC (Hybrid Columnar Compression) in Oracle Databases Running On ZFS Storage Appliance?

HCC (Hybrid Columnar Compression) is appeared only with Exadata but has recently become available to Oracle Databases using ZFS Storage Appliance and Pillar as the database storage. HCC is actually free with Oracle Database Enterprise Edition. No additional database options and no additional ZFS Storage Appliance options are required. HCC requires Oracle Database version 11.2.0.3. To enable HCC in Oracle Databases running on ZFS Storage Appliance, we need to install patch set update of 13343438.

1- Determine whether any currently installed one-off patches conflict with the psu (patch set update) as follows.

unzip p13343438_112030_Linux-x86-64.zip
opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./13343438

Note: Please download correct psu file for your platform (p13343438_11203_.zip)

2- Set your current directory to the directory where the patch is located and then run the OPatch utility as follows.

cd 13343438
$ORACLE_HOME/OPatch/opatch apply

3- The following step loads modified SQL files into the database. For a RAC environment, perform these steps on only one node. For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus and run the catbundle.sql script as follows.

cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL> STARTUP
SQL> @catbundle.sql psu apply

4- Check the following log files for any errors.

vi $ORACLE_BASE/cfgtoollogs/catbundle/catbundle_PSU__APPLY_.log
vi $ORACLE_BASE/cfgtoollogs/catbundle/catbundle_PSU__GENERATE_.log

5- If you are using the RMAN, the catalog needs to be upgraded. Enter the following command to upgrade catalog.

rman catalog username/password@tns
RMAN> UPGRADE CATALOG;

Now, you can use HCC in Oracle Databases running on Oracle ZFS Storage Appliance.

Talip Hakan Öztürk

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: