Oracle 23c installation on Linux

Here we will learn Oracle 23c installation on Linux step by step. In this article we will also learn how to Create and Configure Oracle Database instead of DBCA.

Software Used

In this practice, we are using the following software:

• VirtualBox 7.0
• We are using Oracle Linux 8.4
• Oracle Database 23c Free

System Requirements

The system should be configured as per the below requirements:

RAM	Minimum 1 GB RAM, Recommended 2 GB RAM.
DISK	10 GB Minimum.
Swap Space	Minimum 2 GB swap recommended by Oracle or two times of RAM, whichever is lesser.

Oracle Database 23c Free Installation using RPM Packages

Install and configure Oracle Database 23c Free using RPM packages, but before installing Oracle Database 23c Free, must uninstall the Oracle XE version if already installed.

Let's start the installation of Oracle Database 23c Free using RPM Packages

Login as a root user and follow the below steps.

STEP 1. Enable Developer Channel for the Oracle Linux 8

The below command will automatically install and enable the developer option for Oracle Linux 8.

#dnf install -y oraclelinux-developer-release-el8

STEP 2. Install the Oracle Database Preinstallation RPM

Oracle Database Preinstallation RPM will automatically create the Oracle Installation Ower and Groups and also set all the kernel configuration settings that are required for Oracle Database Installations.

#dnf -y install oracle-database-preinstall-23c

Step 3. Oracle 23c installation on Linux using RPM

The below command performs Oracle 23c installation on Linux in just a few minutes.

#dnf -y localinstall oracle-database-free*

The Oracle 23c installation on Linux is now completed.

Creating and Configuring an Oracle Database

After Oracle 23c installation on Linux, let's create the Database and configure the listener just using the following steps:

# /etc/init.d/oracle-free-23c configure

Oracle Database 23c Free Creation and Configuration is completed.

Set Environment

Login as an Oracle user and set the environment parameters in .bash_profile

#su - oracle

Now edit the .bash_profile and add the below parameters inside then save the file.

$vi .bash_profile

#ORACLE SETTING

export ORACLE_HOME=/opt/oracle/product/23c/dbhomeFree
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=FREE
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
       ulimit -u 16384
       ulimit -n 65536
    else
       ulimit -u 16384 -n 65536
    fi
fi

Create Database connection:

Using the below command create a connection with Database.

$ . .bash_profile --> (Load .bash_profile)
$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Sun Dec 3 17:38:47 2023
Version 23.3.0.23.09

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


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> show con_name

CON_NAME
------------------------------
CDB$ROOT

SQL> show pdbs

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

As you can see the above connection is connected with the Container Database (CDB) by default, Let's Connect with the PDB database.

$ vi /opt/oracle/product/23c/dbhomeFree/network/admin/tnsnames.ora

Connect with PDB now

$ sqlplus sys@FREEPDB1 as sysdba

SQL*Plus: Release 23.0.0.0.0 - Production on Sun Dec 3 17:56:21 2023
Version 23.3.0.23.09

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

Enter password: ENTER YOUR PASSWORD OF SYS USER

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> show con_name

CON_NAME
------------------------------
FREEPDB1

Finally, we have successfully installed and configured the Oracle Database 23c Free on Oracle Linux 8.4.

Oracle 21c installation guide