StandbyMP will revolutionize how organizations manage DR enterprise-wide by making the same Gold Standard of DR available to both Oracle SE and MS SQL Server users - all from a single common user interface.
Back to Blog
By Vijayganesh Sivaprakasam |
January 15, 2024 |
A few months ago, Oracle officially confirmed the compatibility of Oracle Database 19c with Oracle Linux 9, particularly when utilizing UEK7 and a database patch version of 19.19 or newer.
With this assurance, we took the initiative to assess the seamless integration of StandbyMP with OEL-9.2.
The installation of OEL-9.2 on Virtualbox was a trouble-free process, and enough articles are available to guide you through the installation steps. For a helpful guide, check out this resource.
Installing Oracle 19c was a bit more challenging than the OS installation. The pre-installation went fine however when installing, Oracle encountered the error below.
We tried Oracle support’s suggestion to resolve the error, but it didn’t work.
The issue was finally resolved with a released one-off patch from Oracle.
Patch 35775632: PLACEHOLDER FOR STUBS.TAR PATCH FOR OL9 THAT FIXES BUG 33794281
This patch is a straightforward update. All that’s required is the replacement of files in the stubs directory under the $ORACLE_HOME/lib directory.
Following the application of the patch, the Oracle installation went smoothly. The installation of Dbvisit was effortless, and all components were initiated without any complications.
Below are the functions that were tested successfully:
-
Create Configuration
-
Create DR database
-
Enabling Automated Standby update
-
Graceful Switchover
-
Synchronisation
-
Change Database state
-
Edit DDC file
-
Enabling Archive Log Management Module
-
Enabling delayed Archive Log apply
-
Activation
-
Create a standby control file
-
Refresh datafile.
-
Test Standby Activation
-
Perform Read Only testing
After conducting the tests mentioned, we can confidently say that Dbvisit Standby MultiPlatform works flawlessly on Oracle Linux 9.2 with 19c!
If you have any questions on this guide or would like to schedule a POC/Demo, book a time below and one of our technical specialists will contact you.
You can also check out our blog series outlining the benefits of 19c, the upgrade path for RAC customers, and upgrade methods:
-
What's the Difference Between Oracle RAC and Oracle SE2HA? (Part 1)
-
Add Resilience to Oracle SE2HA (or RAC) Clusters with Disaster Recovery (Part 2)
Tags: SQL Server
