Oracle Database, or Oracle RDBMS, is a Database Management System produced by Oracle Corporation. It stores predefined data types and supports SQL for managing and manipulating data. However, not many know we can install Oracle Database on Windows. This guide will show how to install Oracle 11g on your Windows computer easily.
Install Oracle Database on Windows 11
If you want to install Oracle Database on Windows, follow the steps mentioned below.
- Download and extract Oracle database files
- Install Oracle 11g
- Resolve Windows cannot find the URL
- Set up Oracle 11g
- Use Oracle 11g
Let us talk about them in detail.
1] Download and extract Oracle database files
First of all, we need to get the Oracle 11g on our system. If you already have the file, you are good to skip this method and move to the installation part, but if you don’t, navigate to oracle.com which is the official website of Oracle. You will be redirected straight to the download link; you need to click on the Download icon to allow it to start downloading. You will be asked to sign in, if you don’t have an Oracle account, create one, and then download the ZIP file.
After downloading the ZIP file, open File Explorer, go to the Download location and then extract the file. This will create a separate folder in which you will have a folder called DISK 1.
2] Install Oracle 11g
Once we have extracted the ZIP file and went inside the DISK 1 folder, we are required to run the setup file. So, double-click on the setup.exe file to start the installation process. Click on the Next button, agree to the terms and conditions, and then change the installation location if needed. Since I wanted my Oracle 11g to be installed in D drive, I clicked the Browse icon and selected the required location. Make sure to create a folder in that particular location before installing.
You will be asked to set up a password for the SYS and SYSTEM users, also known as user accounts. Set something that can remember as you will be required to use it time and again. Finally, follow the on-screen instructions to complete the installation process.
Read: Difference between SQL and MySQL : Comparision
3] Resolve Windows cannot find the URL
If you get the following error when double-clicking on the Oracle database icon, we need to make some changes.
Windows cannot find ‘http://127.0.0.1:%HTTPPORT%/apex/f?p=4950’. Make sure you typed the name correctly, and then try again.
To resolve it, go to the location where you have installed Oracle 11g, then navigate to App > oracle > product > 11.2.0 > server. For me, the location was D:\oraclexe\app\oracle\product\11.2.0\server. Upon reaching the location, right-click on Get_Started and click on Properties.
Finally, check and make sure that in the Web Document tab, the URL is pointing to http://127.0.0.1:8080/apex/f?p=4950. If required, make the changes and click on Apply.
4] Set up Oracle 11g
After making the aforementioned changes, you will be able to launch Oracle. Upon doing so, you will be redirected to a particular website hosted locally on your computer. Enter the username as ‘SYS’ or ‘SYSTEM’ and the password we set earlier.
Now, we are required to create a workspace. To do that, fill in the required fields and then click on Create Workspace. You will get a link to enter the workspace we have created. Enter the correct credentials to get started.
Read: How to create SQL Stored Procedures via SQL Server
5] Use Oracle 11g
Finally, we can start using Oracle. Since this guide is written by a DBA, we will straightaway head to the SQL Workshop. For that, click on the SQL Workshop icon. From here we can run SQL queries, and create scripts and objects such as Tables, Views, and Index.
To write a query, click on SQL commands. Since we have not done much work to the database, we will try a simple query:
select sysdate, user from dual;
The DUAL table is a unique table that contains only one column and one row. It is present by default in Oracle and other database installations. The table has a single column named DUMMY, which is of type VARCHAR2(1) and has a value of ‘X’. This table can be used to select a pseudo column like SYSDATE or USER.
Similarly, explore the console and get acquainted with the layout.
Read: Fix Unable to Install SQL Server on Windows
How to install Oracle 19c database on Windows?
The process of installing Oracle 19c is similar to that of 11g. However, we recommend you go to docs.oracle.com and follow the guide to install Oracle 19c on your Windows computer. It’s a detailed guide released by Oracle that will assist you in this endeavor of yours.
Read: Open Source Database Software Comparison and Features
How to run Oracle Database in Windows?
Running an Oracle database on Windows is similar to running it on any other platform. You need to go to the Oracle data server, and then in CMD, run sqlplus /NOLOG. Now, you can connect as Sysdba using CONNECT / AS SYSDBA and SQL queries.
Also Read: Move Microsoft SQL Server Database to another drive partition.
