If you have been following my Blog for a while you will by now know I am a long term fan of Oracle on NFS and more accurately Oracle Direct NFS (dNFS). If you need to re-familirise yourself with Oracle dNFS you could do a lot worse than check-out some of my previous Blogs on... Continue Reading →
Block storage IO performance testing with ORION (ORacle IO Numbers)
Background When a DBA gets the request to perform a storage IO test most will probably look to use the extremely poplar, and excellent SLOB (Silly Little Oracle Benchmark) by Kevin Closson, or maybe HammerDB or Dominic Giles'sSwingBench for Transactional / TPC-DS type tests. However, if you find yourself under time or other constraints ORION... Continue Reading →
On-line migration of Oracle 18c/19c 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 19c 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 →
Getting started with the Oracle ZFS Storage VMware Simulator (Part I)
If your like me, you may sometimes need to do some research work with Oracle HCC (Hybrid Columnar Compression), but don't always have access to an Oracle Exadata machine or ZFS Appliance, then the ZFSA simulator may be your saviour. On my Mac I use both VirtualBox and VMware Fusion, but for this Blog post... Continue Reading →