Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog
A technical resource for Data Professionals
Background If you follow my Blog or read my last post on delivering Oracle 18c Express Edition Database (XE) in Kubernetes you may already have Oracle 18XE database up and running on Kubernetes cluster using persistent storage. If not, you may want to read this. In this Blog I am going to show how we... Continue Reading →
In this Blog I am going to show how the Oracle provided Docker build scripts, and the free to use Oracle 18 XE (Express Edition) database can be used to deliver DBA's, developers, data scientists their own database on Kubernetes. The Oracle 18xe Docker build scripts now automatically 'pulls' the database RPM from OTN for... Continue Reading →
Back in April 2017 I blogged on how to use the then official Oracle 12.1 Docker image to run an Oracle 12c database on Docker, if you want to revisit that post you can find it here. However, more recently I shared how you could use Minikube with the latest official Oracle 12.2 Docker image... Continue Reading →
Before we can use DataPump with Oracle dNFS we need to create and export an NFS filesystem, prepare our Linux environment and configure our database. Ok let's begin. Create File System For this walkthrough I need an NFS server, fortunately I have access to a Pure Storage FlashBlade in my lab, so I will be... Continue Reading →
In this Blog I am going to show how the Oracle database 'switch database to copy' can be used to avoid lengthy restore times and therefore minimise downtime in the event of a database disaster. RMAN backup status $ rman target=/ Recovery Manager: Release 19.0.0.0.0 - Production on Wed Apr 8 10:27:26 2020 Version 19.3.0.0.0... Continue Reading →
Overview In this Blog I am going to provide a walthrough of my fully automated Oracle 18 Express Edition (XE) build on a Vagrant managed Oracle Linux VirtualBox virtual machine using Ansible and the Pure Storage FlashArray Ansible collection. I use vagrant up to start my Oracle VirtualBox virtual machine with the latest Oracle Linux... Continue Reading →
If you are using Oracle dNFS (Direct NFS) to deliver or backup your database with Oracle RMAN (Recovery Manager) you may want to consider using Oracle MONDNFS rather than writing you own SQL monitoring scripts. dNFS Views Oracle provide a number of database views to help with the initial configuration and monitoring of dNFS these... Continue Reading →
MiniKube Before we start I will increase the default Minikube VM memory size from 2GB to 10GB, this is required to accommodate my Oracle 12c database, I will also set the MiniKube vm driver to use VirtualBox this can be done by changing the Minikube configuration. If you have not already got MiniKube installed you... Continue Reading →
Background One of the most exciting announcements at last years Oracle Open World #OOW19 was around multi-tenancy and Oracle change of licensing allowing non multi-tenant users to have up to 3 user-created PDB's in a container database at any time. https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/Licensing-Information.html#GUID-AB354617-6614-487E-A022-7FC9A5A08472 With the above, and the announcement of de-support of non-CDB architecture from 20c there... Continue Reading →
In my Getting started with Oracle BigData Blog I shared how you can obtain an example Avro file, if you don't have access to a Avro file you can visit my previous Blog to get started. Bigdata Tools The Apache Avro file stores data in a row-based binary format and therefore not human readable, fortunately we can... Continue Reading →