- Introduction:
- CPU - 2core
- RAM - 4GB
- Disk space - 25GB
- OS - Windows 8.1
- Oracle 19c for Windows : Click Here
C:\Users\oraeasy> mkdir -p D:\app\oracle\product\19c\db_home1
C:\Users\oraeasy> dir D:\app\oracle\product\19c\
Volume in drive D is Data
Volume Serial Number is 60FC-A6D2
Directory of D:\app\oracle\product\19c
30-08-2025 14:22 <DIR> .
30-08-2025 14:22 <DIR> ..
30-08-2025 14:23 <DIR> db_home1
0 File(s) 0 bytes
3 Dir(s) 149,301,039,104 bytes free
2. Now unzip the software.3. Now execute the setup.exe with Run as Administrator option.
4. Now installer GUI window will appear, follow the instructions.
Select Setup Software Only & Click Next.
Select Single Instance & Click Next.
Select the Edition & Click Next.
Select Account type & Click Next.
Click Yes.
Provide ORACLE BASE location & Click Next.
Click Install.
Monitor the progress.
Installation completed. Click Close.
5. Now check Oracle version.
C:\Users\oraeasy> sqlplus -v
SQL*Plus: Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Now we will procced for creation of a database via DBCA utilty.
6. Open a command prompt with Administrator option and run DBCA command.
C:\Windows\System32>dbca
Now DBCA GUI window will appear. Follow the instructions:Select Create Database & Click Next.
Select Advanced Option & Click Next.
Select Single Instance & General Purpose and Click Next.
Provide Database, SID, & PDB name and Click Next.
Select File System & Click Next.
Check FRA & Archive option and Click Next.
We can create Listener later. Click Next.
Click Next.
Define SGA, PGA & Click Next.
If you encountered the "[DBT-50000] Unable to check for available memory" error here, then cancel the DBCA utilty and again execute with below option:
dbca -J-Doracle.assistants.dbca.validate.ConfigurationParams=false
Click Next.
Provide Sys user password & Click Next.
Click Finish.
Monitor the Progress.
Database creation completed & Click Close.
Similarly we can create Listener using NETCA. Please refer Listener Creation using NETCA
7. Now check Oracle services in Services.msc and do the login in command prompt.
C:\Users\oraeasy>lsnrctl status
LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 30-AUG-2025 18:44:03
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LAPTOP-FHSJIP9C)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 19.0.0.0.0 - Production
Start Date 30-AUG-2025 18:43:04
Uptime 0 days 0 hr. 1 min. 2 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\oracle\product\19c\db_home1\network\admin\listener.ora
Listener Log File D:\app\oracle\diag\tnslsnr\LAPTOP-FHSJIP9C\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=LAPTOP-FHSJIP9C)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
Services Summary...
Service "52448234712340b69f274bcc790ecfe0" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 2 handler(s) for this service...
Service "aea9b74252e34877853d9274a1e0037c" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclpdb" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Users\oraeasy> sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Aug 30 18:44:24 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL> SELECT name, open_mode FROM v$database;
NAME OPEN_MODE
--------- --------------------
ORCL READ WRITE
SQL> SHOW PDBS
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
SQL>
Thank you for reading!
I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.
Abhishek Shrivastava
Comments
Post a Comment