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 →
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 →
How to configure the Oracle ZFS Storage Appliance VM simulator for iSCSI Block Storage
Introduction In a previous post last year I have shared how to install and configure the Oracle ZFS Storage Appliance simulator on VirtualBox, and also on VMware Fusion. Earlier this year I shared how to we can use the Oracle ZFA Storage VM to create an environment to experience Oracle Direct NFS (dNFS) with NFSv4.1... Continue Reading →
Oracle 19c Database, NFSv4.1, Oracle Direct NFS (dNFS) and the Oracle ZFS Storage Appliance simulator
Introduction In a previous post I have shared how to install and configure the Oracle ZFS Storage Appliance simulator on VirtualBox, and also on VMware Fusion. In this post I am going to show how we can use an Oracle ZFS Storage Appliance simulator to provide an environment to learn about NFSv4.1 and Oracle Direct... Continue Reading →
How to configure Oracle 19c database and DirectNFS with NFSv4.1
How to configure Oracle 19c database and DirectNFS with NFSv4.1 using a Pure Storage FlashBlade
Oracle 19c on Kubernetes with NFS Storage and Portworx Proxy Volumes
I have previously shared how we can deliver a containerised Oracle 19c database using a Kubernetes Statefulset with Block devices, in this post I will show how we do the same with Kubernetes Deployments and NFS. For this post I will be using Kubernetes v1.17 [root@master-1 ~]# kubectl version --short | awk -Fv '/Server Version:... Continue Reading →
How to access Object Storage from your on-premises Oracle 19c Database
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 →
Oracle Database 19c on Kubernetes with Portworx storage
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 →