Oracle Database 23ai Free installation on Windows and connect with SQL Developer - Oracle 23ai

inchirags@gmail.com Oracle DBA Tutorial https://www.chirags.in

*****************************************************************************************

Oracle Database 23ai Free installation on Windows and connect with SQL Developer - Oracle 23ai

*****************************************************************************************

Hindi YouTube Video:

English YouTube Video:

Oracle Database 23ai Free installation on Windows and connect with SQL Developer - Oracle 23ai Installation Guide

Pre-Installation Requirements

System Requirements

OS: Windows Server 2022 (64-bit)
RAM: Minimum 8 GB
Disk Space: At least 50 GB free space
CPU: Intel or AMD x86-64 processor

User Account:

Use an account with Administrator privileges.

Disable UAC (User Account Control):

Open Control Panel → User Accounts → Change User Account Control Settings

Set to Never Notify.

Firewall Configuration:

Allow TCP port 1521 for Oracle Database.

Install Prerequisites:

Install .NET Framework 4.8 (if not already installed).

Apply the latest Windows Updates.

Step 1: Download Oracle Database 23c (23ai)

Go to the Oracle Technology Network (OTN): Oracle Database Downloads

Download Oracle Database 23c (23ai) for Windows (64-bit).

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

Step 2: Extract the Installer

Extract the downloaded .zip file to a folder (e.g., C:\Oracle23ai).

Open a Command Prompt as Administrator.

Navigate to the extracted folder.

Step 3: Run Oracle Universal Installer

Run setup.exe from the extracted folder.

Follow the installation wizard:

Installation Type: Choose Enterprise Edition (recommended).

Database Configuration: Select Create a database.

Destination Folder: C:\app\oracle\product\23ai\

Administrative Password: Set a strong password (example : Tiger123)

Oracle Base: C:\app\oracle\product\23ai\

Oracle Home: C:\app\oracle\product\23ai\dbhomeFree\

Verify prerequisites and click Install.

Step 4: Configure Listener

Open Net Configuration Assistant (NETCA).

Select Listener Configuration → Add.

Set:

Listener Name: LISTENER
Protocol: TCP
Port: 1521

Start the listener using:

lsnrctl status

if not running then

lsnrctl start

Step 5: Create Database

Open Database Configuration Assistant (DBCA).

Choose Create a database.

Select Advanced Configuration → General Purpose or Transaction Processing.

Set parameters:

Global Database Name: ORCL

SID: ORCL

Enable Automatic Memory Management.

Enable Archiving (if required).

Click Finish to create the database.

Step 6: Verify Database Installation

Open SQL*Plus:

sys as sysdba

or in cmd

sqlplus / as sysdba

Run two query for Open all the pluggable databases by default:

ALTER PLUGGABLE DATABASE ALL OPEN;
ALTER PLUGGABLE DATABASE ALL SAVE STATE;

Run a test query:

SELECT * FROM v$version;

Ensure the database is running:

lsnrctl status

Step 7: Secure Oracle Installation

Run Oracle Database Security Wizard.

Configure password policies.

Enable Database Auditing.

Apply patches using Oracle OPatch Utility.

Step 8: Enable Automatic Startup

Ensure Oracle services start automatically:

Open Services.msc

Locate:

OracleServiceORCL

OracleOraDB23HomeTNSListener

Set Startup Type: Automatic.

Step 9: Confirm You Are in the Correct PDB

Switch to the pluggable database (PDB) where you want to create the user.

Connect as SYSDBA:

sqlplus / as sysdba

Check the current container:

SHOW CON_NAME;

If it shows CDB$ROOT, you are in the container database (CDB), not the pluggable database.

Switch to your PDB (replace PDB_NAME with the name of your pluggable database):

show pdbs;

ALTER SESSION SET CONTAINER = FREEPDB1;

Verify you are now in the PDB:

SHOW CON_NAME;

Step 10: Create the Tablespace

Find the current path of the datafiles:

SQL> SELECT NAME FROM V$DATAFILE;

If you haven’t created the dhruv tablespace, do so first:

CREATE TABLESPACE dhruv 
DATAFILE 'C:\APP\ADMINISTRATOR\PRODUCT\23AI\ORADATA\FREE\FREEPDB1\dhruv01.dbf' 
SIZE 50M 
AUTOEXTEND ON 
NEXT 10M MAXSIZE 1G;

Step 11: Create the User

Create a local user without the C## prefix in the PDB:

show pdbs;

CREATE USER dhruv IDENTIFIED BY Password1 
DEFAULT TABLESPACE dhruv 
QUOTA UNLIMITED ON dhruv;

Step 12: Grant Privileges to the User

Grant necessary privileges to the new user:

GRANT dba to dhruv;

--GRANT CONNECT, RESOURCE TO dhruv;

--GRANT DB_DEVELOPER_ROLE TO dhruv;

Step 13: Verify the User

Log in as the new user to confirm:

sqlplus dhruv/Password1@FREEPDB1

--OR--

Login with SQL Developer:

download SQL Developer from below link:

https://www.oracle.com/in/database/sqldeveloper/technologies/download/

Your Oracle Database 23ai Free installation on Windows is complete. You can now connect to it using SQL Developer. Let me know if you encounter any issues!

For any doubts and query, please write on YouTube video comments section.

Note : Flow the Process shown in video.

😉Please, Subscribe and like for more videos:

https://www.youtube.com/@chiragtutorial

💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Thanks & Regards,

Chitt Ranjan Mahto "Chirag"

_________________________________________________________________________________________

Note: All scripts used in this demo will be available in our website.

Link will be available in description.