Rem: This document explains high level steps to install Oracle Database 23ai on Oracle Linux 9.3
Rem: Steps are taken from Oracle website, Oracle Base and Youtube.
Rem: It is just for knlwege sharing, during actual execution steps may varies as per your enviroment.
Rem: Authors claims no responsbility of using below steps in your environment
Rem: hayathk@hotmail.com
Rem: Hayat Mohammad Khan
Rem: 17-May-2024
Assumption: Oracle Linux 9.3 isn already installed on Oracle Virtual Box
Step#1
Install oracle linux 9 on VirtualBox 7.0
At least 20 GB space on / drive
Step#2
-download RPM from
-- https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/installing-oracle-database-free.html#GUID-46EA860A-AAC4-453F-8EEE-42CC55A4FAD5
--copy to /tmp and from /tmp run below command
dnf -y install oracle-database-preinstall-23ai-1.0-2.el9.x86_64.rpm
Step#3
---download from ->> https://docs.oracle.com/en/database/oracle/oracle-database/23/xeinl/installing-oracle-database-free.html#GUID-46EA860A-AAC4-453F-8EEE-42CC55A4FAD5
--copy to /tmp and from /tmp run below command
dnf -y install oracle-database-free-23ai-1.0-1.el9.x86_64.rpm
Step#4
-- This step is taken from Oralce-baed.com
It will create create CDB (FREE) , and one PDB (FREEPDB1)
--as root user
----define password for sys user (e.g oracle123)
root@sahukw1 tmp]# export DB_PASSWORD=oracle123
[root@sahukw1 tmp]# (echo "${DB_PASSWORD}"; echo "${DB_PASSWORD}";) | /etc/init.d/oracle-free-23ai configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database FREE.
Enter SYS user password:
**********
Enter SYSTEM user password:
********
Enter PDBADMIN User Password:
************
Prepare for db operation
7% complete
Copying database files
.......
..............
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
Connect to Oracle Database using one of the connect strings:
Pluggable database: sahukw1/FREEPDB1
Multitenant container database: sahukw1
Step#5
export ORACLE_HOME=/opt/oracle/product/23ai/dbhomeFree
export PATH=$ORACLE_HOME/bin:$PATH
-- Root container
sqlplus sys/oracle123@//localhost:1521/free as sysdba
--Pluggable database
sqlplus sys/oracle123@//localhost:1521/freepdb1 as sysdba
[oracle@sahukw1 ~]$ sys/oracle123@//localhost:1521/freepdb1 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>
Step#6
Stop / start Services
/etc/init.d/oracle-free-23ai stop
/etc/init.d/oracle-free-23ai start
Note: If disk is full, it can be extend using
Install gparted tool
lvextend /dev/mapper/ol-root -L +5G (my / drive name)
xfs_growfs /dev/mapper/ol-root
Setup Linux GUI Setup: systemctl set-default multi-user
References
https://oracle-base.com/articles/23/oracle-db-23-free-rpm-installation-on-oracle-linux-9
https://blogs.oracle.com/database/post/oracle-database-23c-the-next-long-term-support-release
https://www.youtube.com/watch?v=E9fE9_SL5-s&ab_channel=OCPTECHNOLOGY