Oracle Database 23c is Here!

Oracle is here with their latest version of RDBMS (Relational Database Management System) Technology – Developer edition/release. This allows Developers and DBAs (Database Administrators) across the globe to test the latest features and functionalities and plan their strategy for future releases.

Oracle Database 23ai is going to be the next long-term release after 19c, it would be great to get a head start and get to know more about this release version.

Oracle has provided us with a built-in Virtual Machine with the 23ai edition software installed, we can use that to test our database.

Here are the steps to download the VM set and install it without the hassles of manually creating a Linux VM and installing the software.

1.) Download the Oracle Virtual Box Software (If already present, proceed to step 2) — Select the Windows Installer version.

https://www.oracle.com/ca-en/virtualization/technologies/vm/downloads/virtualbox-downloads.html

• Other options provided are
• Docker Image:
  https://container-registry.oracle.com/ords/f?p=113:10::::::
• RPM File:
  https://www.oracle.com/database/technologies/free-downloads.html

2.) Download the Virtual Machine Image

https://www.oracle.com/database/technologies/databaseappdev-vm.html

Proceed to initiate the download

Provide Oracle Account Login Details to Start the Download

3.) Install the Oracle VM Virtual Box and proceed to Import the Image File

1. Click on File → Import Appliance and select the downloaded Oracle_Database_23c_Free_Developer_Appliance.ova file

Provide the Path and Select “Agree” and being the import

Once the Virtual Machine is installed, click on start→ Normal Start

The Machine Loads with all preset configurations and it also has readme files to list all the database details as follows.

Click on the Sqlcli utility which opens a new session, provides the password to the schema, and begins exploring.