Skip to main content

Oracle Database

Detailed step to install Oracle 21c Express Edition (XE) software, create and configure pluggalbe databases

Oracle 21c Express Edition (XE)​

Download and Install pre-installation package​

Download: oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm

After downloading the pre-installation package upload the file to /usr/local/src on the iCATs server.

scp oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm <IP>@<SERVER>:/usr/local/src

Logon to the iCATs server and install the pre-installation package.

sudo -s
cd /usr/local/src/

# Install the Oracle 21c XE Database package
dnf localinstall -y oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm

Download and Install Oracle 21c XE Database package​

Download: oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm

After downloading the Oracle 21c XE Database package upload the file to /usr/local/src on the iCATs server.

sudo -s
cd /usr/local/src/

dnf localinstall -y oracle-database-xe-21c-1.0-1.ol8.x86_64.rpm

[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database XE, optionally modify the parameters in '/etc/sysconfig/oracle-xe-21c.conf'
and then execute '/etc/init.d/oracle-xe-21c configure' as root.

Verifying        : oracle-database-xe-21c-1.0-1.x86_64
Installed        : oracle-database-xe-21c-1.0-1.x86_64

Complete!

Create a new Oracle 21c XE instance​

/etc/init.d/oracle-xe-21c configure

Specify a password to be used for database accounts.
Oracle recommends that the password entered should be at least 8characters in length,
contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
Note that the samepassword will be used for SYS, SYSTEM and PDBADMIN accounts:

Database creation complete. For details check the logfiles at:
 /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.

Connect to Oracle Database using one of the connect strings:
     Pluggable database: RockyLinux8:1539/XEPDB1
     Multitenant container database: RockyLinux8:1539
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE