Rename LOB – Oracle database 23c New Feature

In Oracle database 23c we can rename LOB segment name by using below command without moving within or other tablespaces. Example – Create table with LOB column and rename the LOB Segment in 23c. Note – Column “ID” is Oracle identity column (Introduced in 12c) similar to “AUTO_INCREMENT” column in MySQL or “IDENTITY” column in … Read more

Oracle Database 23c Free Developer Release Setup step by step on OEL8.

Oracle database 23c installation

Oracle database 23c free developer release is rpm based installation and OEL8 OS is used.

System Requirements 

Operating system : Oracle Linux x86_64. 
RAM : 1GB minimum – 2GB recommended. 
Disk space : 10GB minimum. 
Swap : Minimum 2GB or twice of RAM allocated.

23c Database Developer Version Prerequisites 

Run the below command to enable the Oracle Linux 8 Developer Channel as “root” user. Channel is associated with repository that defines the source of the packages and errata.

dnf install -y oraclelinux-developer-release-el8

Note –   dnf (Dandified YUM) is newer version of yum. Package manager for rpm based Linux distributions.

Run below command to install all prerequisites for installing 23c database as “root” user.

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

Note – As part of pre-installation “oracle” user, groups will be be created andkernel configuration settings required for Oracle installations are set. After completion of pre-reqs create password for Oracle user.

Oracle User Password

passwd oracle

Install 23c Binaries

Download 23c database rpm (oracle-database-free-23c-1.0-1.el8.x86_64.rpm) and ftp to virtual box.

dnf -y localinstall oracle-database-free-23c-1.0-1.el8.x86_64.rpm

Configure 23c Database

Multitenant database. Use dbca or by running below command creates multitenant database with container database “FREE” and one pluggable database “FREEPDB1” with default port 1521.

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

Need to enter password for SYS, SYSTEM and PDBADMIN in the command prompt.

23c Database Login

Login into “oracle” user and set environment variables and login to “FREE” 23c database.

[oracle@localhost ~]$ . oraenv
ORACLE_SID = [oracle] ? FREE
The Oracle base has been set to /opt/oracle

[oracle@localhost ~]$ sqlplus
SQL*Plus: Release 23.0.0.0.0 – Developer-Release on Fri Jun 16 17:06:47 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Enter user-name: / as sysdba
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 – Developer-Release
Version 23.2.0.0.0

SQL> alter session set container=FREEPDB1;

Session altered.

SQL>