Setting Up Oracle 23c Using Vagrant-Projects

Introduction

Oracle Database 23c is the latest release of Oracle's flagship database management system. It includes several new features and enhancements, including:

• JSON Relational Duality: This feature allows developers to store and query JSON data in a relational database. This makes it possible to use the same tools and techniques for both JSON and relational data, which can simplify development and maintenance.
• Operational Graphs: This feature allows developers to store and query graph data in a relational database. This makes it possible to use the same tools and techniques for both graph and relational data, which can simplify development and maintenance.
• Microservices support: This feature allows developers to build and deploy microservices on top of Oracle Database. This can simplify development and maintenance, and can also improve performance and scalability.
• Real-time machine learning: This feature allows developers to train and deploy machine learning models on top of Oracle Database. This feature can improve the performance and readings of applications, and turndown the need for data movement.
• Support for new data types: It allows the developers to store and query data in a variety of data types like JSON, XML, and spatial data. This makes the storage and query data much efficient and improves the performance of the application.

Now let us see how we can setup an environment to explore the above mentioned features locally.

To install Oracle 23c using vagrant-projects, you will need to have the following:

• Install Oracle VM VirtualBox
• Install Vagrant

After we install the above two tools we need to clone the repository as mentioned below

git clone https://github.com/oracle/vagrant-projects

Once the repository is cloned, navigate to and  type “vagrant up”  to initiate the installation process:

 “..\vagrant-projects\OracleDatabase\23.2.0-Free”

Wait till all the setups are completed.






 
 Once you see the below line on your command prompt you are ready to use your Oracle 23c:
 

oracle23c-free-vagrant: INSTALLER: Installation complete, database ready to use!

To connect your the database let us ssh to the server and try to login following the below steps:

C:\Users\Owner\Desktop\Study\oracle-vm\vagrant-projects\OracleDatabase\23.2.0-Free>vagrant ssh
==> vagrant: Getting Proxy Configuration from Host...

Welcome to Oracle Linux Server release 8.7 (GNU/Linux 5.15.0-5.76.5.1.el8uek.x86_64)

The Oracle Linux End-User License Agreement can be viewed here:

  * /usr/share/eula/eula.en_US

For additional packages, updates, documentation and community help, see:

  * https://yum.oracle.com/

[vagrant@localhost ~]$ sudo su - oracle

The above  "sudo su - oracle"  command will connect you to oracle user. The passwords are auto generated but we can modify the passwords using the below commands.

[oracle@localhost ~]$ cd /home/oracle
[oracle@localhost ~]$ ls
setPassword.sh
[oracle@localhost ~]$ ./setPassword.sh <<Your New password>>

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Apr 10 14:41:01 2023
Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL>
User altered.

SQL>
User altered.

SQL>
Session altered.

SQL>
User altered.

SQL> Disconnected from Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

Now let us connect to the database using the new password:

[oracle@localhost ~]$ sqlplus sys as sysdba

SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Mon Apr 10 14:41:23 2023
Version 23.2.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0

SQL>

So now we are all set to use the new developer released version of Oracle 23c and try out all the new features provided by Oracle.


Thank you for reading this article please feel free to leave me some feedback or to suggest any future topics. I'll be looking forward to hearing from you – Swadhin Ray  (Sloba)
  
 For more information about me, please check out my Experts Exchange Profile page.