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.
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.
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>
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.
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]
We have tested all the actions, settings and tests to ensure that these work fine.
[Image: StandbyMP Actions Panel with Oracle 23ai]
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.