Various thoughts on Oracle, Enterprise Architecture, Cloud Computing, Kubernetes and everything Storage
Introduction Last year I wrote a number of posts on Big Data and shared how we can access CSV, Parquet and Avro file formats directly from an on-premises Oracle 19c database. In these posts I demonstrated how we can access different file types using SQL external tables on a file system, unfortunately I quickly run... Continue Reading →
Introduction In this short post I will share how we can automate the refresh of an Oracle database on Windows in few seconds with a simple PowerShell script and the Pure Storage PowerShell SDK. Database Volumes In my lab I have an 2 Oracle database each using 2 volumes for the database, which are presented... Continue Reading →
Introduction In a previous post I introduced ORCA for Windows and shared a Video of it in use, in this post we will spend a bit of time looking at some of the techniques I used to implement it.. Working with Ansible Templates One of the Ansible features I find myself using time and time... Continue Reading →
Introduction I have previously blogged on how a simple Ansible playbook can be used to automate the cloning of Oracle database(s) on Linux, utilising the Pure Storage Ansible modules and storage snapshots. If you're interested my Ansible code for Oracle Rapid Clone Automation (ORCA) can be found up on GitHub or if you prefer to... Continue Reading →
Introduction If you follow my blog or have read my post Oracle Database 19c on Kubernetes with Portworx storage you may have an Oracle database running on Kubernetes and are wondering how do I protect it. In this post I will show you how we can use Portworx Volume Group Snapshots to complement other backup strategies.... Continue Reading →
In this post I am going to show how we can take volume and volume group snapshots with Portworx. I have previous blogged on how you can run an Oracle 19c on Kubernetes with Portworx and will use the PVCs created that blog within this post. Inspect existing Statefulset Before we start let's looks out... Continue Reading →
I have previous blogged on how you can run an Oracle 19c on Kubernetes with Portworx, if you want to check out the code examples you can find them here. In this post I am going to show how we can use a Portworx Storage Class and Persistent Volume Claims (PVCs) to resize a containers... Continue Reading →
Background In this post I am going to share how you can obtain the official Oracle 19.3 Enterprise Edition (EE) Docker image and deliver an Oracle 19c database on Kubernetes 1.17.0 with Portworx 2.6 storage. Kubernetes Cluster Info Before we start let's have a look at our Kubernetes environment $ kubectl cluster-info Kubernetes master is... Continue Reading →
Background If you have followed Part 1 and Part 2 you should have a already downloaded the Oracle 19.3 Docker image from the Oracle Container Registry and have tried it out in your environment. In this post I will be using Minikube and VirtualBox to run an Oracle 19c database within Kubernetes environment. Kubernetes -... Continue Reading →
Oracle 19c Docker Image In Part 1 of this Blog series I showed how you can obtain the official Oracle 19.3 Docker image from the Oracle Container Registry, if you missed the you can read more about getting the Oracle 19c image here. You can still use the Oracle provided Docker build scripts to roll... Continue Reading →
