Fully automated Oracle #APEX build using #Oracle18xe, #ORDS and Apache Tomcat @ansible @virtualbox @oracleace
On-line migration of Oracle 18c filesystem datafiles to Oracle ASM
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 18c Oracle database from an existing storage platform to a new storage array. Prepare ASM... Continue Reading →
Creating new Oracle 18c ASM Disk Groups
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 →
Adding new devices (VMware) to Linux without re-booting server
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 →
Creating Oracle HCC (Hybrid Columnar Compression) on your Laptop
In this Blog we will take-out a newly created Oracle ZFS VMware Simulator for a test ride by trying to create some Oracle HCC (Hybrid Columnar Compression) data. If you don't have access to an Oracle storage platform, you may want to visit my previous posts in the series Part I or Part II Two... Continue Reading →
Getting started with the Oracle ZFS Storage VMware Simulator (Part II)
In this Blog post I will share how your newly created Oracle ZFS Storage VMware Simulator can be used to deliver storage for an Oracle 12c database via dNFS and also support HCC (Hybrid Columnar Compression). Hopefully you have followed Part I of my Blog post on Getting Started with the Oracle ZFS Storage VMware... Continue Reading →
Oracle 12c Multi-database refresh with Ansible
In this Blog post I will share another short video demonstrating how storage data services can be used to perform many common data management tasks using simply scripting, DevOPS automation tools and Pure Storage REST API’s . Oracle 12c multiple databases clones with Ansible Before we jump into the demonstration let me detail my architecture and explain... Continue Reading →
Part 3: Oracle 12c Point-in-Time-Recovery
In this Blog post I will share another short video demonstrating how storage data services can be used to perform many common data management and CDM (Copy Data Management) tasks using simply scripting, DevOPS automation tools and Pure Storage REST API’s . Oracle 12c Point-in-Time-Recovery This video starts the same as a Part 1: Oracle 12c database reset by... Continue Reading →
Part 2: Oracle 12c database rewind
In this Blog post I will share another short video demonstrating how storage data services can be used to perform many common data management and CDM (Copy Data Management) tasks using simply scripting, DevOPS automation tools and Pure Storage REST API’s . Oracle 12c database rewind This video starts the same as a Part 1: Oracle 12c... Continue Reading →
Oracle dNFS Throughput testing
Oracle Direct NFS In my previous Oracle dNFS Blog post I detailed how to configure Oracle 12cR2 to use Oracle dNFS multi-path, in this Blog I will share some test results that I achieved in my Oracle 12cR2 Pure Storage FlashBlade lab. Theoretical Limits A Gigabit Ethernet network can transmit 1,000,000,000 bits per second, as we normally... Continue Reading →