AWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 2/3 – Connectivity and what you get

This is the second part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. In this part we take a look how we can connect to the Oracle database host and to the database itself by a tool like the Oracle SQL Developer. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this…

Read More

AWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 1/3 – Setup

Some weeks ago I saw in an AWS public presentation a topic about a RDS service for Oracle databases where you can build your own environments and get full OS access. This was new for me how knows the normal AWS RDS offerings for Oracle databases, where no (or very limited) OS access is possible. And this meant for me as a child of Oracle Cloud Infrastructure: time to play! I spent a lot of time in the last three…

Read More

Oracle Cloud Infrastructure Quick Tip – Use the Bastion Service with MobaXterm

Mobatek’s MobaXterm is my favorite terminal for the daily work. It supports a lot of protocols like SSH, RDP, VNC, integrates X11 and SFTP and many more. And, MobaXterm can be used to connect to your OCI compute instance by the Oracle Cloud Infrastructure Bastion Service and the Managed SSH Session feature. Prerequisites OCI Compute Instance running in a private subnet OCI Bastion plugin enabled on Compute Instance – be patient when you enable it for the first time and…

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…

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