How to Install Oracle 21c and SQL Developer on Windows 10

If you're planning to use Oracle 21c and SQL Developer on your Windows 10 machine, this guide will walk you through the process step by step. We'll start with downloading the necessary software, followed by the installation and configuration of Oracle 21c, and then setting up SQL Developer for database management.

Step 1: Download the Software
Oracle Database 21c: Download from Oracle 21c Windows Downloads
SQL Developer: Download from SQL Developer Downloads

Step 2: Install Oracle 21c
Extract the downloaded WINDOWS.X64_213000_db_home.zip.
Run setup.exe to begin the installation.

Configuration Steps:
Configuration Option: Select Create and configure a single instance database and click Next.
Database Installation Options: Select Desktop class.
Oracle Home User: Choose Create New Windows User with the following credentials:
Username: myoracleuser
Password: oraclepasswordduringSetup1
Typical Installation:
Oracle base: C:\oracle21c
Database file location: C:\oracle21c\oradata
Database edition: Enterprise Edition
Character set: Unicode (AL32UTF8)
Global database name: orcl
Password: oraclepasswordduringSetup1
Pluggable database name: orclpdb


Click Next to proceed with the installation.
Troubleshooting:
If your Oracle 21c installation cannot proceed due to existing Oracle services, follow these steps to stop and delete the conflicting services:
1.Open the terminal as an administrator.
2.Run the following commands to stop and delete the services:
SC STOP OracleJobSchedulerORCL
SC STOP OracleOraDB19Home1MTSRecoveryService
SC STOP OracleOraDB19Home1TNSListener
SC STOP OracleRemExecServiceV2
SC STOP OracleServiceORCL
SC STOP OracleVssWriterORCL


SC DELETE OracleJobSchedulerORCL
SC DELETE OracleOraDB19Home1MTSRecoveryService
SC DELETE OracleOraDB19Home1TNSListener
SC DELETE OracleRemExecServiceV2
SC DELETE OracleServiceORCL
SC DELETE OracleVssWriterORCL

3.Restart your computer and try the installation again.

Step 3: Install SQL Developer
Extract the downloaded sqldeveloper-23.1.1.345.2114-x64.zip.
Run sqldeveloper.exe to start SQL Developer.

Creating a Connection in SQL Developer:
Click the green + button to create a new connection.
Fill in the connection details:
Username: sys
Password: oraclepasswordduringSetup1
Role: SYSDBA
Save Password: Check this box.
Hostname: localhost
Port: 1521
SID: orcl
Click the Test button to check the connection. If successful, click the Connect button.
Example SQL Queries

Creating a Table
CREATE TABLE EMPLOYEE(
    EMPID INT,
    FIRSTNAME VARCHAR(255),
    LASTNAME VARCHAR(255)
);


Inserting Data:
INSERT INTO EMPLOYEE (EMPID, FIRSTNAME, LASTNAME) VALUES (1, 'Kape', 'Tinapay');
INSERT INTO EMPLOYEE (EMPID, FIRSTNAME, LASTNAME) VALUES (2, 'Kamote', 'Kangkong');
INSERT INTO EMPLOYEE (EMPID, FIRSTNAME, LASTNAME) VALUES (3, 'Tamban', 'Bagoong');


Updating Data:
UPDATE EMPLOYEE SET FIRSTNAME = 'NewName', LASTNAME = 'NewLastName' WHERE EMPID = 2;


Deleting Data:
DELETE FROM EMPLOYEE WHERE EMPID = 2;


Selecting Data:
SELECT * FROM EMPLOYEE;


Comments in SQL Developer:
Single-line comment: -- This is a comment
Multi-line comment: /* This is a multi-line comment. It can span across lines. */

By following these steps, you will have Oracle 21c and SQL Developer up and running on your Windows 10 machine, allowing you to manage and interact with your databases efficiently.