Oracle 21c Installation Guide on Windows

 

Oracle 21c Installation Guide on Windows

This guide walks you through installing Oracle Database 21c on Windows and configuring it for local use with SQL Developer.

🖥️ Pre-Installation Requirements

Ensure your system meets the following:

• OS: Windows Server 2019 or later (64-bit) or Windows 10/11 (64-bit)
• RAM: Minimum 8 GB (16 GB recommended)
• Disk Space: At least 50 GB free
• CPU: Intel or AMD x86-64 processor
• User Account: Administrator privileges

🔧 System Configuration

• Disable UAC:
  Control Panel → User Accounts → Change User Account Control Settings → Never Notify
• Firewall:
  Allow inbound TCP traffic on port 1521
• Install Prerequisites:

• .NET Framework 4.8 or later
• Latest Windows updates

📦 Step-by-Step Installation

Step 1: Download Oracle 21c

• Visit the Oracle Database 21c Downloads page
• Download the Windows x64 ZIP file

Step 2: Extract the Installer

• Extract the ZIP to a directory like C:\Oracle21c
• Open Command Prompt as Administrator
• Navigate to the extracted folder

Step 3: Run Oracle Universal Installer

• Run setup.exe
• Follow the wizard:
• Installation Type: Enterprise Edition (recommended)
• Database Configuration: Create a database
• Destination Folder: C:\app\oracle\product\21c\
• Oracle Base: C:\app\oracle\product\21c\
• Oracle Home: C:\app\oracle\product\21c\oradata
• Admin Password: Choose a strong password
• Verify prerequisites and click Install

🔌 Step 4: Configure Listener

• Launch Net Configuration Assistant (NETCA)
• Choose Listener Configuration → Add
• Set:

• Listener Name: LISTENER
• Protocol: TCP
• Port: 1521

To start listener manually:

lsnrctl status lsnrctl start

Or update listener.ora:

ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) )

🗃️ Step 5: Create the Database

• Launch Database Configuration Assistant (DBCA)
• Choose Create a database
• Select Advanced Configuration → General Purpose or Transaction Processing
• Set:

• Global Database Name: ORCL
• SID: ORCL
• Enable Automatic Memory Management
• Enable Archiving (optional)

Click Finish to create the database.

🧑‍💻 Step 6: Connect with SQL Developer

• Download Oracle SQL Developer
• Create a new connection:

• Username: system
• Password: your admin password
• Hostname: localhost
• Port: 1521
• SID: ORCL

🛠️ Troubleshooting Tips

• If listener fails to start, check firewall and port settings
• Use tnsping ORCL to verify connectivity
• Ensure environment variables like ORACLE_HOME and PATH are correctly set

Oracle Database on Oracle Linux: Pre-requisite Setup Guide (Beginner Edition with Pre-install RPM 19c and 21c Edition)

Oracle Database on Oracle Linux: Pre-requisite Setup Guide (Beginner Edition with Pre-install RPM) 

This guide prepares a fresh Oracle Linux system for installing Oracle Database (19c or 21c), using the oracle-database-preinstall RPM to automate most of the setup.

1. Base OS Setup

• OS Version: Oracle Linux 7 or 8 (64-bit), minimal install preferred

Update System

sudo yum update -y

sudo reboot

Enable Required Repos:

sudo yum install -y oraclelinux-release-el7

sudo yum-config-manager --enable ol7_latest ol7_optional ol7_addons

📦 2. Install Oracle Pre-install RPM

Oracle provides a pre-install RPM that configures:

• Required OS packages
• Kernel parameters
• Shell limits
• Oracle user and groups

For Oracle 19c on Oracle Linux 7:

sudo yum install -y oracle-database-preinstall-19c

For Oracle 21c on Oracle Linux 8:

sudo dnf install -y oracle-database-preinstall-21c

💡 This step automatically creates the oracle user, oinstall and dba groups, and sets kernel/shm parameters.

📁 3. Create Oracle Base Directory

Even though the RPM sets up the user, you still need to create the Oracle base manually:

sudo mkdir -p /u01/app/oracle sudo chown -R oracle:oinstall /u01 sudo chmod -R 775 /u01

🧠 4. Verify Kernel Parameters and Limits

The RPM sets values in /etc/sysctl.conf and /etc/security/limits.d/oracle-database-preinstall-19c.conf. You can verify with:

sysctl -a | grep shm ulimit -a

👤 5. Set Oracle Environment Variables

Edit /home/oracle/.bash_profile:

export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1 export ORACLE_SID=ORCL export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib

🧪 Adjust paths if you're installing 21c or using a custom ORACLE_HOME.

🧩 6. Optional: GUI Setup for Installer

If using Oracle’s GUI installer:

• Install X11 packages:

sudo yum install -y xorg-x11-utils xorg-x11-xauth

• Enable SSH X11 forwarding:

ssh -X oracle@your-host

• Or use VNC for remote GUI access

✅ Final Checklist Before Installation

Item	Minimum Requirement
Swap Space	2 GB or more
Disk Space in /u01	10–15 GB free
Hostname	Properly set and resolvable
Oracle User	Created by RPM
Kernel & Limits	Set by RPM