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

How to stand out on Social Media as an Entrepreneur

Ever since the world has progressed and unveiled the potential of human minds, the Industrial revolution and triumph of futuristic designed technologies has brought...

Best Tech Deals in Amazon Great Indian Festival Sale 2021

If you also plan to take a new product, then prepare your Wishlist because Amazon Great Indian Festival Sale is going to start soon....

Best Tech Deals in Flipkart Big Billion Days 2021

Flipkart hosts its annual event, big billion days where this e-commerce giant will bring in a variety of brand items for sale in a...