Oracle 19c installation on Windows 10 + Video Tutorial

In this Oracle tutorial, we will see a complete step-by-step on Oracle 19c installation on Windows 10. Also, we will see, how to install oracle database 21c on windows 10.

Also, we will cover these topics.

  • Brief History of Oracle database & its versions
  • System requirements for installing Oracle on Windows
  • Oracle database installation steps for windows
  • Uninstall Oracle Database from windows
  • Reset password for sys as sysdba database
  • Installing Oracle SQL Developer Tool
  • how to install oracle database 21c on windows 10

Brief History of Oracle database & its versions

Oracle database is a powerful and safe relational database software created by Oracle corporation. It was developed in 1977 by three friends Larry Ellison, Bob Miner, and Ed Oates at SDL (Consultancy Software Development Lab).

YearDescription
1977the first version was released in the name RSI (Relational Software Inc.)
1979Oracle version 2 was released as the first commercially based RDBMS
1982A portable version of the oracle database was released as Oracle version 3. Company name changed from RSI to Oracle Systems Corporation
1985Oracle V4, V5, V6 were released with Enhancements to concurrency control, data distribution, and scalability.
1992Oracle V7 released with PL/SQL store program unit.
1997Oracle V8 released with objects and partitioning
1999Oracle V8i released with Internet computing
2001Oracle V9i released with Oracle Real Application Clusters (Oracle RAC)
2003Oracle V10g released with Grid Computing
2007Oracle database 11g released with the following features: Manageability, diagnosability, and availability.
2009Oracle database 11g release 2 with Edition Based Redefinition, Hybrid Columnar Compression, Replication, Database Appliance, Cluster File System, Golden Gate, Data Redaction.
2013Oracle Database 12c Release 1 with features like Database Cloud Service, In-Memory Column Store,  JSON, Native, SQL Pattern Matching, Multitenant architecture
2017Oracle Database 12c Release 2 with features like  Zero Data Loss Recovery Appliance, Native Sharding, etc.
2018Oracle Database 18c released with features like Online Merging of Partitions and Subpartitions, Active Directory Integration, etc.
2019Oracle Database 19c was released which is the latest stable version so far. It has Automated PDB Relocation,  Automatic SQL Plan Management, , Zero-Downtime Grid Infrastructure Patching, etc.
2021Oracle Database 21c is in innovation mode and it supports advanced features related to blockchain, machine learning,  SQL Macros, etc.

Read How to Get List all Tables in Oracle Database

Oracle 19c Installation on Windows 10 Step by Step

System Requirements for Oracle 19c installation on windows 10

Let us check out the system requirements for installing Oracle 19c installation on Windows 10.

Here are the important components (software & hardware) required to install the oracle database in your system. In case your system didn’t meet these requirements please then please go with the minimum configuration setting.

Also, check: How to Install Oracle on Docker

Software Requirement for Installing Oracle Database on Windows

The following windows operating system can be used to install the oracle database on it. Windows 11 is still in the beta version we tried installing it on it & it worked for us but we do not guarantee that it will work for you as well. Once support is officially released we will update this section.

  • Windows 8.1 x64- Pro and Enterprise editions
  • Windows 10 x64- Pro, Education, and Enterprise editions.
  • Windows Server 2012 R2 x64- Standard, Datacenter, Essential, and Foundation centers.
  • Windows Server 2016 x64- Standard, Datacenter, and Essentials centers.
  • Windows Server 2019 x64- Standard, DataCenter, and Essentials centers.

Read: Connect to oracle database

Hardware Requirement for Installing Oracle Database on Windows

In this section, we have mentioned the hardware required to install and run the oracle database on the windows operating system.

System ArchitectureProcessor: AMD64 and Intel EM64T
RAM (random access memory)2 GB minimum
Virtual Memory– If physical memory is between 2 GB and 16 GB, then set virtual memory to 1 times the size of the RAM
– If physical memory is more than 16 GB, then set virtual memory to 16 GB
colors256 colors
Resolution 1024 X 768 minimum
Disk space10 GB

Read How to Check Oracle Database Version

Oracle 19c installation on Windows 10

In this section, we will walk you through the steps to download and install the oracle database 19c on your windows operating system (Windows 10).

  • We highly encourage you to download the Oracle database from the official website. Click on the below button to navigate to the exact download page. Please note that you will need an Oracle account to download the file.
  • Once downloaded, extract the file in the location of your choice. We have extracted the file in our download folder but we advise you to create a new folder ‘Oracle’ inside windows C:/ and then extract the zip file there C:/Oracle
  • Navigate inside the WINDOWS.X64_193000_db_home folder and run the setup file as Administrator.
Oracle 19c installation on windows 10
Oracle Database Setup
  • ‘Select configuration Option’ wizard will open, choose the first option which says ‘create and configure a single instance database’ and click on Next button.
Oracle 19c installation on windows 10
Step 1: Select Configuration Option
  • Once configuration is selected then ‘System Class’ wizard will open. In this wizard, you can select between desktop class and server class.
    • Desktop class povides starter database and allows minimal configuration.
    • Server class provides all the tools & configurations to facilitate production data center work.
oracle 19c download for windows
Step 2: Select System-Class
  • ‘Specify Oracle Home User’ wizard will open, here you can choose any option as per your preferences. In our case, we have selected ‘create new windows user‘ and providednew user name & password. Once completed this step click on the next button.
oracle 19c installation on windows step by step
Step 3: Oracle Home User
  • ‘Typical Install Configuration’ wizard contains the most important configurations please makea note of the credentials.
    • Oracle base holds the path of extracted zip file. In our case, zip file is extracted in the downloads folder that is why downloads path is displayed.
    • Database file location is the path where database is stored. New folder with the name oradata is created.
    • Select Enterprise Edition in data base edition dropdown.
    • Global database name is the important here please remember whatever name you are going to provide it.
    • This password will be used to access orcl global database. The password must have uppercase, lowercase, number and special character to meet the oracle standard.
    • Plugged database name is also important please keep a record of it to avoid trouble in future. Click on next button.
oracle database 19c download
Step 4: Typical Install Configuration
  • Once the Typical install configuration is completed the system will perform prerequisite checks where it will check for various parameters and that will be step 5. Once all the checks are passed it will redirect you to the Summary wizard.
  • In the ‘Summary’ wizard all the setting you have selected so far will be displayed and from here we will move to install the orace database 19c software, click on the install button to proceed.
oracle 19c installation step by step
oracle database installation step 6: summary
  • Next wizard is ‘Install Product’, Here the product will be installed on the device, this may take some time. You will see green ticks for all the completed steps. Also, there will be a ‘windows security alert’ prompt. click on the allow access.
oracle installation on windows
step 7: Install product
oracle download for windows 10
Allow Access to Windows Defender Firewall
  • Once the installation is complete ‘finish’ window will appear. The oracle database 19c is successfully installed in your system now.
install oracle 19c installation on windows 10
Step 8: finish
  • Once the installation is complete its time to use oracle database 19c. Open command prompt and type sqlplus / as sysdba to connect with the system predefined database.
oracle 19c download for windows
Oracle Database 19c overview

Read How to create a database in Oracle 19c

How to install oracle database 21c on windows 10

Here is a complete video tutorial on how to install oracle database 21c on windows 10.

Uninstall Oracle Database from windows

In this section, we have shared the steps to uninstall the Oracle 19c from the Windows operating system. These steps will remove all the programs and files of the oracle database from your system.

The steps shared are based upon the installation method we have taught in the above section – Oracle 19c installation on Windows 10

Uninstallation of Oracle database involves the following steps:

  1. Close all the instances of oracle running on the windows.
  2. Stop all the oracle services
  3. Remove the base folder from C:\
  4. Remove Oracle folder from C:\Program Files
  5. Remove Oracle folder from C:\Users\Youruser
  6. Delete Environment Path
  7. Delete oracle database information from Registry

Close all the instances of oracle running on the windows

Open task manager and close all the running instances of the Oracle database and oracle SQL developer tool from your windows operating system.

Oracle 19c uninstallation from Windows 10
Close all the instances of an oracle database running on the windows

Stop all the oracle services

  • Open Run by pressing WIN + R on the keyboard and type services.msc
  • Stop all the running services of oracle as displayed in the below picture.
Oracle 19c uninstallation from Windows 10
Stop all the oracle database services

Remove the base folder from C:\

The base folder is the one where all the oracle files are stored. It is recommended to create a base folder inside the C:\ drive directly. Delete the base folder of the oracle database permanently.

The below image shows the files inside the base folder.

Oracle 19c uninstallation
Remove the base folder of the oracle database

Remove Oracle folder from C:\Program Files

Navigate to C:\Program Files and there you will find the oracle folder. If you do not have any other oracle program installed like Oracle virtual box, etc. then delete the entire folder otherwise delete the inventory folder only.

Remove Oracle folder from C:\Users\Youruser

Navigate to C:\Users\Username in some cases it is inside the app data. Navigate there and delete the oracle folder from there even if the folder is empty.

Delete Environment Path of oracle database

After installing oracle, an oracle software path is created automatically on the System Environment Variable. This allows the use of sqlplus on the command prompt.

  • To delete the Environment path search for Edit the System Environment Variables on the windows search.
  • Click on the Environment Variables button on the bottom right of the window.
  • Under the System Variables, in the Path section, you will see the path of oracle.
  • Select the oracle path and click on the delete button. Don’t forget to click on the Ok buttons of the window.

The below diagram shows, the deletion of the environment path of the oracle database in windows.

Uninstall Oracle 19c from Windows 10
Delete Environment Path of oracle database

Delete oracle database information from Registry

The registry keeps the information about all the software installed on the system. It is one of the crucial record keeper of the windows operating system.

Note: Please follow these steps carefully, any mistake could break your operating system.

  • Open Run by pressing WIN + R and type regedit.
  • Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\
  • If there is no other oracle software installed then delete the entire oracle folder from there otherwise delete the folders mentioned in the below image.
Uninstall Oracle 19c from Windows
Delete oracle database information from Registry
  • Navigate to Computer\HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services\ and delete all the oracle services from there.
  • Below image shows the oracle services on the registry of windows 10.
How to Uninstall Oracle 19c from Windows
Delete oracle database services from Registry

Reboot your computer and it will be free from all the files and folders of the oracle database. The system will treat the reinstallation as fresh installation on windows 10.

Read: Oracle 19c Installation on Windows 10

Reset password for sys as sysdba

Sys users do not require passwords while logging in if not changed manually. In this section, we will learn how to reset passwords for sys as sysdba database.

  • After installing oracle database 19c on your system you can login to sysdba without any password and can create new database, grant permissions, etc.
  • sysdba cannot left without password due to security reasons. Once you have logged in, set the password for sysdba to avoid unauthorised access.
  • Sys password can be changed using Alter Command in oracle database.
# login to sysdba
sqlplus / as sysdba

# change password (here TOOR is the new password)
ALTER USER SYS IDENTIFIED BY TOOR;

Read Connect Excel to Oracle Database

Download and Installing Oracle SQL Developer Tool

In this section, we have demonstrated how to download and install the Oracle SQL developer tool on the windows operating system.

  • Oracle SQL Developer tool is an open source tool that provides a workspace for the development of the databases using Graphical User Interface (GUI) and supports all the other tools from Oracle.
  • This tool will help you while dealing with huge database as information displayed over the command-line is not as clear as it appear on the IDE.
  • We encourage you to download oracle sql develper tool from the official website. Click on the above button and download Windows 64-bit with JDK 8 included.
  • Once downloaded extract the zip file inside C:\Program Files folder of your windows machine.
  • Navigate to the sqldeveloper folder and click on the sqldeveloper application to start the progam.
Oracle 19c installation on windows 10
Oracle SQL Developer Tool

Also, take a look at some more tutorials on the Oracle database.

In this tutorial, we have learned how to install Oracle on the Windows operating system. Also, we have covered these topics.

  • Brief History of Oracle database & its versions
  • System requirements for installing Oracle on Windows
  • Oracle database installation steps for windows
  • Reset password for sys as sysdba database.
  • Installing Oracle SQL Developer Tool