Oracle ZFSSA Storage Appliance – disabling SNMP service kills the Hybrid Comlumnar Compression functionality

In a customer project, we are running several ZS7-2 Oracle ZFS Storage Appliances ZFSSA in bundled with Private Cloud Appliances PCA. The ZFSSA is a very powerful storage solution with a lot of functionality like OISP (Oracle Intelligent Storage Protocol), or – when an ADVANCED COMPRESSION license is yours – Hybrid Columnar Compression HCC. But once in a day when I tried to create a Hybrid Columnar Compression enabled tablespace in a 19c pluggable database in our test system, I…

Read More

Oracle Database Appliance – let’s backup to the Oracle Cloud Infrastructure Object Storage

This blog post describes the setup for an Oracle Database Appliance ODA database backup by RMAN to the Oracle Cloud Infrastructure. Basically there are three destinations for backup and recovery possible: • Oracle Fast Recovery Area (FRA) disk – the Internal FRA • Network File System (NFS) location – external FRA • Oracle Cloud Infrastructure Object Storage – Oracle Object Storage When using backup to the Oracle Cloud Infrastructure Object Storage, the Oracle Database Backup Cloud Service module (opc_installer.jar) is…

Read More

Oracle Database Appliance X6-L Memory Expansion – Overwritten HugePage Settings after Reboot

A Customer has extended his Oracle Database Appliance X6-L with Oracle Database Appliance Memory Expansion Kit from 192GB to 384GB. After the first startup, the odacli tool has recognized the additional available memory and gave us the suggested value for the new HugePage settings. The ODA has the newest available patchset applied, OS is Oracle Enterprise Linux 6.10. Update the OS Configuration Oracle suggested the new values for the HugePage settings to 135350MB.  [root@srv20 ~]# odacli list-osconfigurations Parameter User ConfiguredValue…

Read More

Oracle Database Appliance X6 – resize your /u01

Basically on an ODA X6-L the directory /u01 has the size of 100 GB. With seven different ORACLE_HOME directories for the Oracle databases and the Grid Infrastructure software, there is no disk space left for patching the Oracle Database Appliance. ODA patches require between 13 GB and 15 GB free space on /u01 for the new software. Just FYI – during the patch process a new stage directory called /u01/patching is created where the new software is temporarily located. Patch…

Read More