Oracle 21c Express Edition - setup and installation

After downloading the 21x expression from the oracle site extract the zip file in any empty folder and click on setup.exe.

https://www.oracle.com/in/database/technologies/xe-downloads.html

 

Accept the terms and conditions.

Change the install directory path if required.

Set a password for the database SYS/SYSTEM users

Summary details of installation.

Installation progress.

Note the following 

Multitenant container database : localhost:1521

Pluggable database : localhost:1521/XEPDB1

EM Express URL : https://localhost:5500/em

You can login to Enterprise Manager to monitor the health of the database

You can test your connection to the database as follows

>sqlplus system/oracle123@xe

You can locate the tnsnames.ora and listener.ora files at the following path.

%ORACLE_HOME%\homes\OraDB21Home1\network\admin

tns entry for XE PDB is as follows

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-GHTEO05)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)
    )
  )

LISTENER_XE =
  (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-GHTEO05)(PORT = 1521))

Listener for XE database is as below

 

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\install\21cXE\dbhomeXE)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:E:\install\21cXE\dbhomeXE\bin\oraclr.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-GHTEO05)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

You will need to add a tns entry for XEPDB1 in tnsnames.ora to connect to XEPDB1 database.

Sample tns entry is below.

XEPDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-GHTEO05)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = XEPDB1)
    )
  )

C:\Users\winni>sqlplus SYSTEM/oracle123@XEPDB1

SQL*Plus: Release 21.0.0.0.0 - Production on Thu May 30 09:48:13 2024
Version 21.3.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Last Successful login time: Thu May 30 2024 09:43:46 +05:30

Connected to:
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0

SQL> 
  

Thought for the day

Give thanks for a little, and you will find a lot.

Hausa Proverb