How to Install Oracle Database on Windows in 2021

What is Oracle?

An oracle is a database where multiple data are taken as a single unit. It is a multi-model database management system that has been marked by Oracle Corporation. This database is used for running online transaction processing, data warehousing and mixed database workload. It was first designed for enterprise grid computing. It is the most flexible and cost-effective way to manage information and applications. Oracle is easy to learn and one can understand it well if they have a fair knowledge of SQL
server.

Its latest version oracle 19c was released in 2019 and is one of the updated versions of oracle. Many don’t understand how to install oracle database in their windows pc or desktop. Here are the steps to do so.

Steps to install Oracle

  1. install oracle database from oracle website in your computer using the given link: https://www.oracle.com/database/technologies/oracle-database-software-downloads.html
  2. extract the given folders to your specific computer drive
  3. double click on the setup.exe file to start installing it in your website
  4. you will be asked to provide the email address for receiving the latest security updates
  5. if not needed you can click on next
  6. if you haven’t provided the email address a pop up will occur whether you want to confirm it or not.
  7. click on the required action
  8. next you will be asked if you want to create or configure your database. This step is necessary.
  9. you can install the requirement database software or can upgrade the given software
  10. if you have clicked oracle database for the first time, click on “Create and configure a database” and click on next
  11. you will be asked to choose the system class.
  12. usually, you need to install oracle database and not a server, so click on “desktop class” and continue with next
  13. In the next step, you need to mention your windows user account and configure your oracle home for enhanced security.
  14. Here, you must use “Use windows built in account”
  15. Choose the folder where oracle database will be installed. Also mention your global database name and password and pluggable database name.
  16. A pre requisite check is processed
  17. review the global settings summary and click install button if you find everything to be okay.
  18. the oracle database will be installed
  19. this may take some time depending on your computer and internet speed
  20. Enter password for SYS and SYSTEM accounts and then click on Ok
  21. If your installation is completed successfully, then you will get a confirmation message and close the window.

How to Connect to Oracle Database

  1. launch the SQL developer application given by the oracle database
  2. right click on connection node and choose “new connection”
  3. This is done to create a new connection
  4. write the information that you had provided during installation and click on “connect” This is done to get connected to the oracle database.
  5. SQL developer displays all the required objects that are displayed below.

Finally, you are done with the installation of oracle 12c on your desktop.

Conclusion:

With simple steps, you are able to install your oracle database and get started.
If you want to add an entry in the tnsnames.ora file, then first you need to see in which directory it is located in. This is located in:

C:\app\\product\12.1.0\dbhome_1\network\admin\

If you go according to the steps, then your file is located in the given directory:

C:\app\product\12.1.0\dbhome_1\network\admin\

Also, Read | Best Gaming Monitors under 10000 to buy in India (2021)

Follow Us on Google News to Stay Updated

More from author

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Looking for Great Deals ? Click Here

Related posts

Latest posts

Best Graphics Cards under 50000 in India (August 2021)

Introduction Graphics Card prices have been on the rise since the craze of crypto mining has gone up. But if you are looking to buy...

What is GitHub Co-pilot? | Will it affect existing jobs

Introduction GitHub Co-pilot is an AI pair programmer that helps a person to write a code faster with less amount of work. It is basically...

Everything you need to know about Pegasus Virus

What is Pegasus? Pegasus is a spyware brought in by the NSO group from Israeli cyber intelligence firm. This malware can hack any IOS...