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 By default, Portworx thin provisions volumes and balances them according to current usage and load within the cluster, requiring only minimal configuration. This approach enables applications to provision volumes simply as long as you have enough backing storage for the volume usage. However if the volume usage exceeds your available backing storage, and allocating... 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 →
Background In this post I am going to walkthrough how you can get, and install the Oracle ZFS Storage Appliance simulator on VirtualBox. I will then share how we can create an NFS filesystem and configure SNMP to support HCC (Hybrid Columnar Compression). Download OVA Start by downloading the 3.4GB Oracle Storage Appliance Simulator software... Continue Reading →
Background Historically most of the conversations I have regarding Oracle Recovery Manager (RMAN) are around the use of NFS storage such as a Pure Storage FlashBlade, and Oracle Direct NFS (dNFS). However, with more Oracle customers deploying databases in Oracle Cloud Infrastructure (OCI) and / or using Object Storage for backups I thought it was... Continue Reading →
Background In my last post I shared how to deploy Portworx by Pure Storage on the Oracle Container Engine for Kubernetes (OKE) within the Oracle Cloud Infrastructure (OCI). In this post I will share how we can automate the build of an OKE cluster using Terraform. Terraform for Oracle Cloud Infrastructure (OCI) If you want... Continue Reading →
Oracle Cloud Infrastructure (OCI) In this blog I will show how we can use Portworx with the Oracle Container Engine for Kubernetes (OKE) service within the Oracle Cloud. For this post I created a 5 node OKE cluster and 5 Block devices which I attached to each compute instance using iSCSI. OCI Compute Instances OCI... Continue Reading →
