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 →
How to change an Oracle ASM Diskgroups section size
Traditional disk based storage systems use a sector size of 512 bytes, some all-flash-arrays use 4K sectors sizes, but it's not something we generally consider, do you know what you are using ? If you're not sure you may want to check-out now of my recent posts on how to check disk sector sizes from... Continue Reading →
Oracle 19c RAC database online migration to ActiveCluster for extended / stretched RAC clusters
In this post I will share how to perform an online move of an Oracle 19c RAC database to a Pure Storage ActiveCluster Pod to provide Active-Active synchronous replicated storage for an extended / stretched Oracle RAC cluster. Step 1 - ActiveCluster Pod The first step is to create a Pod, in the example below... Continue Reading →
Portworx Data Services (PDS) and PostgreSQL
Introduction In this blog post I will introduce Portworx Data Services (PDS) and demonstrate how it an be used to also deliver PostgreSQL databases. I have previously shared how we can use the EDB Kubernetes Database Operator to deliver a PostgreSQL database, and also the YugabyteDB Kubernetes Database Operator to deliver a PostgreSQL compatible Yugabyte... Continue Reading →
Oracle 21c warm failover with the Oracle Database Kubernetes Operator (OraOperator), OCI and Portworx storage
Background In Getting started with Oracle 21c, Oracle database Kubernetes operator (OraOperator), OCI and Portworx storage I shared details of my Terraform script which I use to build OKE clusters with Portworx storage. I detailed how to install the Oracle Database Kubernetes Operator and how to configure it for a single instance database running on Oracle... Continue Reading →
Oracle 21c with the Oracle Database Kubernetes Operator (OraOperator) and Portworx storage
Background In Getting started with the Oracle Database Kuberenetes Operator (OraOperator) I introduced the Oracle Database Kubernetes Operator and provided details on how to install and configure it for a single instance database running on Oracle Container Engine for Kubernetes (OKE) service within Oracle Cloud Infrastructure (OCI). In the post I share how I use... Continue Reading →