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 →

Getting Up and Running with Oracle 19c on NFSv3

Background As many of you may already know, I have been a long time supporter of running Oracle on NFS, having deployed many Oracle E-Business suite, single instance and RAC databases on NFS over years. However, for many Oracle DBAs NFS (Network File Systems) is still something of an unknown entity, in this post I... Continue Reading →

Create a website or blog at WordPress.com

Up ↑