Oracle Database 23ai Free version setup on Linux - rpm based (simplified)

 - rpms to download

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

oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm

-- run the pre-install rpm

# dnf -y install oracle-database-preinstall-23ai-1.0-2.el8.x86_64.rpm

-- verify

# rpm -qa | grep -i database

oracle-database-preinstall-23ai-1.0-2.el8.x86_64

-- Install database via rpm

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

Note: your last message must be like below:

Installed:

  oracle-database-free-23ai-1.0-1.x86_64

Complete!

-- Now verify:

# rpm -qa | grep -i database

oracle-database-free-23ai-1.0-1.x86_64

oracle-database-preinstall-23ai-1.0-2.el8.x86_64

-- Oracle Database 23ai Creation and Configuration

# cd /opt/oracle/product/23ai/dbhomeFree

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

e.g.,

# /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:
Password cannot be null. Enter password:
The password you entered contains invalid characters. Enter password:
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
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
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: ugbu-mum-98/FREEPDB1
     Multitenant container database: ugbu-mum-98
#

-- Database status check
# /etc/init.d/oracle-free-23ai status
Status of the Oracle FREE 23ai service:
LISTENER status: RUNNING
FREE Database status:   RUNNING
#
-- verify pmon
$ ps -ef | grep pmon
oracle     39598       1  0 07:16 ?        00:00:00 db_pmon_FREE
oracle     44957   44346  0 07:36 pts/0    00:00:00 grep --color=auto pmon

-- Check the database

$ sqlplus / as sysdba
SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Thu Oct 24 07:22:07 2024
Version 23.5.0.24.07
Copyright (c) 1982, 2024, Oracle.  All rights reserved.
Connected to:
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.5.0.24.07
SQL> 

Note: From 23ai onwards, non-container database option not available. Default is container based database

SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select name,open_mode,database_role,log_mode from v$database;
NAME      OPEN_MODE            DATABASE_ROLE    LOG_MODE
--------- -------------------- ---------------- ------------
FREE      READ WRITE           PRIMARY          NOARCHIVELOG
SQL> select BANNER from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
SQL>
SQL> show pdbs;
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 FREEPDB1                       READ WRITE NO
SQL> alter session set container=FREEPDB1;
Session altered.
SQL>

-- To connect from client / application / oracle developer, you can add an entry to tnsnames.ora file 
e.g.,

FREEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <your-server-ip/host>)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = FREEPDB1)
    )
  )