I’m really excited to announce that Dbvisit StandbyMP now supports Oracle 23ai. This follows significant testing by the testing team and myself in various Oracle 23ai environments. 

Oracle 23ai is the next Long Term Release of the Oracle Database, available in Oracle Cloud (OCI) now and on-premise in the first half of CY2024. 

In this article, I explain how to install the 23ai Free Developer Release. I'll guide you through integrating it with Dbvisit Standby MultiPlatform (StandbyMP), enabling your organization to harness the latest features of Oracle 23ai while ensuring robust Disaster Recovery for Oracle SE databases.

Installing 23ai Free Developer Release 

The installation of the 23ai Free-Developer Release is simple. I tried this in a Linux environment.

The pre-installation and installation were executed using an RPM (Redhat Package Manager) package. The installation was done in OEL8.6.

  
[root@nzel81 ~]# rpm -ivh /home/oracle/oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
Verifying...                    ################################# [100%]
Preparing...                    ################################# [100%]
Updating / installing...
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-23ai.conf' and then run '/etc/init.d/oracle-free-23ai configure' as root.

Creating the primary database

Running the script ‘/etc/init.d/oracle-free-23ai configure' as root automatically created a new database “FREE” with a single PDB.

[oracle@nzel81 ~]$ sqlplus
SQL*Plus: Release 23.0.0.0.0 - Production on Mon May 13 21:52:59 2024
Version 23.4.0.24.05
Copyright (c) 1982, 2024, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
SQL> sho pdbs

CON_ID CON_NAME         OPEN MODE  RESTRICTED
---------- ------------------------------
2 PDB$SEED              READ ONLY  NO
3 FREEPDB1              READ WRITE NO
SQL>

Creating the standby environment 

Changing to Archivelog Mode

By default, all new databases created are in no archivelog mode. The next step was to put it in archivelog mode and then repeat the steps to install 23ai on a second server. I did not create a database on my second server, but I will install Dbvisit and use it as a DR server.

Installing the Dbvisit StandbyMP on Primary and Standby Servers

StandbyMP Agent installation went smoothly on the primary server.

I installed Agent and Controlcenter on the standby server.

View the full installation instructions from the user guide. 

The next steps were easy. I created a DDC and then the standby database, with the automated standby update interval set to the default 600sec and the observer enabled (standby monitoring functionality within StandbyMP) for monitoring my configuration.

                                                                [Image: Standby DB Creation Succesfull in StandbyMP]

All StandbyMP actions tested and available

We have tested all the actions, settings and tests to ensure that these work fine.

              [Image: StandbyMP Actions Panel with Oracle 23ai]

Summary - StandbyMP is ready for Oracle's 23ai LT release

Dbvisit StandbyMP and Oracle 23ai work well together as organisations can now create resilient Oracle SE environments with Dbvisit StandbyMP and leverage the improvements of Oracle 23ai.

What's next:

• Current customers implementing StandbyMP with Oracle 23ai should download the latest version Download.  
• If you want to learn about creating a resilient Oracle SE environment by implementing a warm standby database on Oracle 23ai then request a demo with me here.  
• Trial Dbvisit StandbyMP with Oracle 23ai by downloading a trial license Download.