Where’s my Oracle Database Volumes?

Introduction A question I've heard a number of times from Oracle DBAs is I am using an Everpure (formerly Pure Storage) FlashArray for my Oracle Database, but how do I know what FlashArray is hosting my database volumes and what names does the Storage Admin know them by? Mapping FlashArray Volumes OK, for physical Linux... Continue Reading →

Upgrading Oracle Database 19c to Oracle AI Database 26ai with AutoUpgrade

Introduction In this blog post I will share how to use the Oracle AutoUpgrade utility to upgrade an Oracle 19c (19.30.0.0.0) Database to Oracle AI Database 26ai (23.26.1.0.0). If you have yet to configure Oracle AutoUpgrade or created an Oracle AI Database 26ai Oracle Home check-out How to create an Oracle AI Database 26ai environment... Continue Reading →

How to create an Oracle AI Database 26ai environment with AutoUpgrade

With the on-premises Oracle AI Database 26ai database now GA (generally available) many of us are exciting reading-up on all the new features, discussing database upgrades with server and storage teams, speaking with developers about testing and scheduling regression testing with application owners. But before we start we need to prepare an environment. Pre-Installation Storage... Continue Reading →

How to Configure NVMe over TCP (NVMe/TCP) on Oracle Linux 9

Background Over the recent months I have an increasing number of discussions around the use of Non-volatile Memory Express™ (NVMe™) over TCP (NVMe/TCP) storage and Oracle, so I thought it was time I documented how to configure NVMe/TCP on Oracle Linux 9 for Oracle Database 19c. Is this NVMe over TCP supported ? Yes, Oracle... Continue Reading →

Installation and Configuration of the new Oracle ASMLib v3.1 on Oracle Linux 9

Introduction Following the recent announcement of the deprecation and desupport of the Oracle ASM Filer Driver (ASMFD), and the release of a new version of the Oracle ASMLib for Oracle Automatic Storage Management (ASM). It's the perfect time to revisit ASMLib and write a blog on how to download, install, and configure the ASM library... Continue Reading →

Automated Oracle Database Refresh with Workato

Introduction I recently had the opportunity to spend some time learning all about the Workato orchestration platform. After completing the Workato training paths and certifications I decided it was time to take my new found knowledge out for a spin. In the short video at the end of this post I will demonstrate how a... Continue Reading →

Oracle Database Storage Array Usage and Data Reduction Ratio Analysis

I was recently asked Does a Pure Storage FlashArray include empty, unused Oracle Database space within its data reduction calculation ?. As I am sure many others may have had the same question, I thought it would make a good topic for a blog post, so here we go. FlashArray Data Reduction From the FlashArray... Continue Reading →

Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels

Background As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering. AFD can ensure writes are only performed by trusted and registered Oracle processes, blocking potentially damaging writes that would have otherwise resulted in data corruption. Unfortunately, a recent Linux... Continue Reading →

Reclaim Storage space using the Oracle ASM Filter Driver (ASMFD)

Background Ok, what is the Oracle ASM Filter Driver ? The Oracle ASM Filter Driver (Oracle ASMFD) is an Oracle provided Linux kernel module that resides in the IO path of the Oracle ASM disks. Oracle ASMFD provides a number of advantages over the use of ASMLIB and UDEV managed volumes, these include: storage protection... Continue Reading →

Working with Oracle Linux 8 and iSCSI

Oracle Linux Server Configuration For this blog post I will be using an Oracle Linux 8 server and a Pure Storage FlashArray to demonstrate how block volumes can be presented to an Oracle Linux 8 database server via iSCSI. Let's start by logging in as root and configuring the Linux database server to support Internet... Continue Reading →

Create a website or blog at WordPress.com

Up ↑