PCA X9-2 – Console Connection – How To

In a customer project, we have two Oracle Private Cloud Appliance X9-2 up and running. The management of a PCA X9-2 is almost like in Oracle Cloud Infrastructure. Even when the style of the user interface is not so cool. This week after a change on a virtual machine, the machine was not able to boot again. As in OCI, then Console Connection is the best way to troubleshoot the situation and gather more information. In this blog post I show you how to connect to a virtual machine from a Windows platform. See here for the virsh connection when no VCN viewer is available: PCA X9-2 – Console Connection – virsh Version Architecture Prerequisites Documentation – PCA 3.0.2 https://docs.oracle.com/en/engineered-systems/private-cloud-appliance/3.0/user-3.0.2/user-usr-compute.html#usr-instance-consoledisplay…

Read More

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 got this error: ORA-64307: Exadata Hybrid Columnar Compression is not supported for tablespaces on this storage type SQL> CREATE BIGFILE TABLESPACE ts_data_hcc_01 2 DATAFILE SIZE 200m AUTOEXTEND ON NEXT 10m MAXSIZE 100G 3 LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT…

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 configured in the background. A configuration can be created by the ODA browser interface or by command line tool odacli – what I prefer. When you have already worked with the Oracle Database Backup Service and the OPC module, the…

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 SuggestedValue ————— ————— —————————— ————— Memlock grid 386716274KB 386716168KB Memlock oracle 386716274KB 386716168KB HugePage default 67815MB 135350MB According the Oracle documentation Oracle® Database Appliance X6-2S/X6-2M/X6-2L Deployment and User’s Guide – Section 13.14 – we updated the OS configuration by odacli.…

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 Apply failed – Not enough free Space If there is not enough free space available, update processes like updating a database home fail. [root@oda-srv2046 ~]# odacli describe-job -i f024f27d-7c9a-43fc-9ae8-4f99ef809280 Job details —————————————————————- ID: f024f27d-7c9a-43fc-9ae8-4f99ef809280 Description: DB Home Patching: Home Id…

Read More