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

Oracle 23c 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 23c 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 23c while ensuring robust Disaster Recovery for Oracle SE databases.

Installing 23c Free Developer Release 

The installation of the 23c 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.

       
Verifying...                    ################################# [100%]
Preparing...                    ################################# [100%]
Updating / installing...
1:oracle-database-preinstall-23c-1.################################# [100%]
[root@nzel81 oracle]# rpm -ivh oracle-database-free-23c-1.0-1.el8.x86_64.rpm
Verifying...                    ################################# [100%]
Preparing...                    ################################# [100%]
Updating / installing...
1:oracle-database-free-23c-1.0-1   ################################# [100%]
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.nj

Creating the primary database

Running the script ‘/etc/init.d/oracle-free-23c 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 Wed Mar 27 22:04:01 2024
Version 23.3.0.23.09
Copyright (c) 1982, 2023, Oracle.  All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 23c Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.3.0.23.09
SQL> sho pdbs

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

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 23c 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 StanbyMP 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 23c]

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

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

What's next:

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