In this Blog Series I am going to share how to deploy the Oracle Database 23c Free Developer Release on an Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE) Cluster with Portworx storage. In Part 1 of this blog series I shared how to create an OKE Kubernetes Cluster. In this Part 2... Continue Reading →
How to migrate Oracle ASM UDEV managed disks to Oracle ASMFD (Filter Driver)
I have previously shared how to install the Oracle ADM Filter Driver (ADMFD) using the CLI and also using the Oracle Installer graphical UI. In the post I will share how to migrate existing Oracle ASM UDEV managed disks to use the newer ASM Filter Driver (ASMFD). To confirm ASM Filter Driver has already been... Continue Reading →
Oracle Database 23c Free Version Now Available to Developers
Before you check the date of the post, no it's not 1st April, and yes Oracle has just announced the very exiting news that Oracle Database 23c Free-Developer Release is now available for Developers. Oracle Announcement You can find out more information about Oracle Database 23c Free–Developer Release at https://www.oracle.com/database/free And read the new features and... Continue Reading →
How to Clone and run an Oracle Database in a Docker Container
During a recent conversation, I was asked How can I clone my Production Oracle 19c database, and run the database clone in a Docker container ? Great question, I hear you asking. Well, I have been talking about Docker, Kubernetes and Containerisation for many years but when I checked I had no video demonstrating how... Continue Reading →
Protect Kubernetes Portworx volumes with CloudSnap to OCI S3 Object Storage
In this post I will share how we can use Portworx CloudSnap to backup a Kubernetes Portworx volume to an Oracle Cloud Infrastructure (OCI) Object Storage S3 Bucket. OCI Object Storage Let's start by logging into an Oracle Cloud Infrastructure (OCI) account, and from the Dashboard selecting Object Storage or via the hamburger menu navigate to Storage -> Object Storage -> Buckets.... Continue Reading →
How to deploy an on-premises 21c database using the Oracle Database Operator for Kubernetes
Background The Oracle Database Operator for Kubernetes (OraOpeator) provides a simple, supported method of provisioning, cloning, and patching Oracle Databases including databases deployed on Kubernetes. I have previously posted a blog on how to use the OraOperator (v0.1.0) to deliver an Oracle database on the Oracle Cloud Infrastructure (OCI) Oracle Container Engine for Kubernetes (OKE)... Continue Reading →
Use PL/SQL to perform Storage Snapshots from within the Oracle Database using UTL_HTTP
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. I have previously shared how to perform File System snapshots on a Pure Storage FlashBlade using the UTL_HTTP package, in this... Continue Reading →
Manage Infrastructure with REST APIs from within the Oracle Database using UTL_HTTP
In this blog post I will share how the Oracle UTL_HTTP package can been used to enable full stack automation by calling external application and infrastructure REST APIs from within an Oracle 19c or 21c database. For the purpose of this post I will be using an Oracle 21c database and a Pure Storage FlashBlade... Continue Reading →
Accessing on-premises S3 Object Storage from Oracle 19c or 21c databases with DBMS_CLOUD
In this post I will share to how to create an external table using the DBMS_CLOUD package and then run a query against a csv file uploaded into a Pure Storage FlashBlade S3 Object Storage bucket. I have previously shared how to install and configure the Oracle DBMS_CLOUD package, if you want to follow this... Continue Reading →
Working with Oracle 19c database and on-premises S3 Object Storage with DBMS_CLOUD
The DBMS_CLOUD package has been available for on-premises 19c database for over a year now, and since the initial 19.9 release several fixes have been shipped, so I suggest you consider using the latest patch if possible, to avoid any known issues. I have previously shared how to configure an Oracle 19c database to use DBMS_CLOUD... Continue Reading →