Oracle Client Silent Installation on OEL8

Download oracle client from Oracle web site and copy to Linux machine. Unzip the file to any location. “client” folder will be extracted. Edit Response File client_install.rsp file will be available in “client” folder -> “response” folder. Paths need to be according to your system. set the following parameters – UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/oraclient/oraInventory ORACLE_HOME=/u01/oraclient/app/oracle/product/21.0.0/client_1 ORACLE_BASE=/u01/oraclient/app/oracle oracle.install.client.installType=Administrator … Read more

Display Date and Time for DATE Datatype.

Session Level To display time with date for DATE datatype in SQLPLUS/SQL Developer/Toad etc. we can set “NLS_DATE_FORMAT” at session level using below command. alter session set nls_date_format = ‘DD-MON-YYYY HH24:MI:SS’; Permanent Settings to Display Date Format in SQL Developer In SQL developer we set at session level or make change in settings and display … Read more

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 XE Windows – Oracle Database 21c Express Edition

Download Oracle XE from Oracle website and extract the zip file. Open or double click “setup.exe” – Accept the License Agreement and click Next – Choose the PATH where XE binaries needs to be installed – Enter Database and Confirmation Password – Click on install to start installation and click Finish after completion – Workspace … Read more

Oracle XE Linux – Oracle Database 21c Express Edition

Oracle 21xe Installation on OEL8 – Installation is performed using Oracle 21c xe RPM and all installation steps will be executed as “root” user. System Requirements & Limitations – Operating system – Oracle Enterprise Linux 8 used in this article.Network Protocol Supported – IPC, UDP, TCP/IP, TCP/IP with SSL.RAM – 1 GB of RAM minimum. … 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>