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