Ron Ekins' – Oracle Technology, DevOps and Kubernetes Blog
A technical resource for Data Professionals
In Part 1 of this blog series I shared how to create a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket. In Part 2, I showed how we can use the MySQL Shell... Continue Reading →
In Part 1 of this blog series I shared how to setup a Pure Storage FlashBlade S3 compliant Object Storage account, user and bucket. I also demonstrated how to download the MySQL airportdb database, and upload objects into the Object Store S3 bucket. In this blog post I will show how we can use the... Continue Reading →
In this blog post series I and going to share how a MySQL 8 DBA can utilise S3 Object Storage for common database admin activities. If you don't already have an up and running MySQL 8 database and want to follow this blog, you could check out my post How to Install MySQL 8 on... Continue Reading →
In this post I am going to share how to install the MySQL 8 Community Edition on Oracle Linux 8. Before you download the RPM, confirm which version of Linux you are using, by checking /etc/redhat-release or /etc/oracle-release, for example. # cat /etc/redhat-release; cat /etc/oracle-release Red Hat Enterprise Linux release 8.8 (Ootpa) Oracle Linux Server... Continue Reading →
I was recently asked 'How can I check to see if my storage supports 4K sector sizes, and if my Oracle 19c database is using it' ? In this post I will share how to check disk sector sizes from Linux, from Oracle Automatic Storage Management (ASM) and via the Oracle kfed utility. Traditional disk... Continue Reading →
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 →
Fully automated Oracle #APEX build using #Oracle18xe, #ORDS and Apache Tomcat @ansible @virtualbox @oracleace
Background Prior to Oracle 12c moving non-ASM data files required taking data files ‘offline’ and negotiating an outage with the business, since Oracle 12c this is has no longer been the case. I was recently challenged with moving a good size filesystem 19c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →
Creating New Volumes Create the new ASM volume(s) using your storage platform, for this blog I have created 3 volumes on a Pure FlashArray, simply providing names and sizes. Note the Volume serial numbers, these will be used in the multipath configuration wwid (World Wide Identifier) SCSI storage device serial numbers are universally unique. Each... Continue Reading →
Background Today, I found myself needing to add 3 new disks to one of my Oracle database server VMware VM's, unfortunately I was unable to re-boot the server so I followed the steps below to add the new devices. Create LUN's using your storage platform and add add them to your Virtual Machine using... Continue Reading →