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).
| Year | Description |
|---|---|
| 1977 | the first version was released in the name RSI (Relational Software Inc.) |
| 1979 | Oracle version 2 was released as the first commercially based RDBMS |
| 1982 | A portable version of the oracle database was released as Oracle version 3. Company name changed from RSI to Oracle Systems Corporation |
| 1985 | Oracle V4, V5, V6 were released with Enhancements to concurrency control, data distribution, and scalability. |
| 1992 | Oracle V7 released with PL/SQL store program unit. |
| 1997 | Oracle V8 released with objects and partitioning |
| 1999 | Oracle V8i released with Internet computing |
| 2001 | Oracle V9i released with Oracle Real Application Clusters (Oracle RAC) |
| 2003 | Oracle V10g released with Grid Computing |
| 2007 | Oracle database 11g released with the following features: Manageability, diagnosability, and availability. |
| 2009 | Oracle database 11g release 2 with Edition Based Redefinition, Hybrid Columnar Compression, Replication, Database Appliance, Cluster File System, Golden Gate, Data Redaction. |
| 2013 | Oracle Database 12c Release 1 with features like Database Cloud Service, In-Memory Column Store, JSON, Native, SQL Pattern Matching, Multitenant architecture |
| 2017 | Oracle Database 12c Release 2 with features like Zero Data Loss Recovery Appliance, Native Sharding, etc. |
| 2018 | Oracle Database 18c released with features like Online Merging of Partitions and Subpartitions, Active Directory Integration, etc. |
| 2019 | Oracle 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. |
| 2021 | Oracle 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
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 Architecture | Processor: 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 |
| colors | 256 colors |
| Resolution | 1024 X 768 minimum |
| Disk space | 10 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 thereC:/Oracle - Navigate inside the WINDOWS.X64_193000_db_home folder and run the setup file as Administrator.
- ‘Select configuration Option’ wizard will open, choose the first option which says ‘create and configure a single instance database’ and click on Next button.
- 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.
- ‘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.
- ‘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.
- 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.
- 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.
- Once the installation is complete ‘finish’ window will appear. The oracle database 19c is successfully installed in your system now.
- Once the installation is complete its time to use oracle database 19c. Open command prompt and type
sqlplus / as sysdbato connect with the system predefined database.
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:
- Close all the instances of oracle running on the windows.
- Stop all the oracle services
- Remove the base folder from
C:\ - Remove Oracle folder from
C:\Program Files - Remove Oracle folder from
C:\Users\Youruser - Delete Environment Path
- 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.
Stop all the oracle services
- Open Run by pressing
WIN + Ron the keyboard and type services.msc - Stop all the running services of oracle as displayed in the below picture.
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.
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.
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 + Rand typeregedit. - 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.
- 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.
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 Filesfolder of your windows machine. - Navigate to the sqldeveloper folder and click on the sqldeveloper application to start the progam.
Also, take a look at some more tutorials on the Oracle database.
- How to create table in Oracle
- Oracle to_char Date Format
- Oracle Add Foreign Key
- Oracle add primary key
- Oracle to_date Format
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
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.