Before I start any new software install I find it's good practice to check the Oracle Certification Matrix on My Oracle Support (MOS). The ASM Filter Driver MOS document is -> ASMFD (ASM Filter Driver) Support on OS Platforms (Certification Matrix). ( Doc ID 2034681.1 ) ... Oracle Linux – RedHat Compatible Kernel 7 3.10.0-123 and later... 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 →
Oracle 12c Online Database Move Datafile
After watching an Oracle R12c new features presentation at a recent conference somebody asked me what was my favourite Oracle R12c database feature, for me it was easy has to be 'ALTER DATABASE MOVE DATAFILE' Prior to Oracle 12c moving non-ASM data files required taking data files 'offline' and negotiating an outage with the business, with... Continue Reading →
Resizing Oracle ASM disks
Resizing Oracle ASM disks with pure storage
Using udev rules with OL / RH7 on VMware Fusion
Preparing to use udev rules on VMware Fusion Before you can use udev rules with your new VMware Hard Drives you need to update the Virtual Machines .vmx file and set the following. disk.EnableUUID = "TRUE" Without this setting the '/usr/lib/udev/scsci_id' command will no values. As with all configuration files it's best practice to create a... Continue Reading →
