Oracle 23ai Installation on Linux

In this article, we will look at installation and configuration of oracle 23ai on Oracle Linux 8. The steps are same for Oracle Linux 9. We will be using Oracle Database 23ai RPM for this activity

• Oracle 23ai Pre- requisites

• Installing and configuration Oracle 23ai

Oracle 23ai Pre-requisites

Install the 23ai preinstall package using dnf utility. This package will perform all the pre-requisites on your Linux server

dnf install -y oracle-database-preinstall-23ai

Download the Oracle 23ai rpm package using wget

wget https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el8.x86_64.rpm

Install Oracle 23ai

As root user, install the 23ai rpm package using the dnf utility

dnf install -y oracle-database-free-23ai-1.0-1.el8.x86_64.rpm

Configure FREE database with FREE PDB and creating sys and system user password

/etc/init.d/oracle-free-23ai configure

Switch to Oracle user and setup the bash profile

su - oracle
vi .bash_profile

Add ORACLE_SID, ORACLE_BASE, ORACLE_HOME and update the PATH variable

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs
export ORACLE_SID=FREE
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree

PATH=$PATH:$HOME/.local/bin:$ORACLE_HOME/bin

export PATH

Export bash profile

. .bash_profile

Connect to sqlplus and start the Oracle 23ai database

sqlplus / as sysdba
SQL> startup
SQL> show pdbs;