Installing Oracle 12c On Windows

Overview

Purpose

This tutorial shows you how to install the Oracle Database 12c software on Microsoft Windows along with a default instance of an Oracle Database that contains example schemas ( including the HR schema).

Time to Complete

Approximately 1 hour.

Introduction

The Oracle Universal Installer (OUI) is used to install the Oracle Database software. OUI is a graphical user interface utility that enables you to:

View the Oracle software that is installed on your machine
Install new Oracle Database software
Delete Oracle software that is no longer required

During the installation process, OUI will start the Oracle Database Configuration Assistant (DBCA) which can install a precreated default database that contains example schemas or can guide you through the process of creating and configuring a customized database.
If you do not create a database during installation, you can invoke DBCA after you have installed the software, to create one or more databases.

To launch the Oracle Client Installer, go to the destination folder, open the client directory, and then double-click setup.exe (the Oracle 12c setup file). At this point: Windows may prompt you for an administrator username and password. Enter an administrator username and password to proceed. Windows may present an 'Open File - Security Warning' dialog box. Click Run to proceed. It may take a minute for the 'Oracle Client Installer' window to appear.

Install Oracle Database 12C on Windows 7,8,10 Posted on July 13, 2019 by joda3008 This article presents how to quickly install Oracle Database 12C Release 2 (12.2.0.1) on Windows.
Oracle Client 12C (32 bit) Installation on Windows 7 (64 bit) In this document we will describe installation process for Oracle Database Client on Windows 7 (64 bit). To correct anything, please write mail to.
Oracle 12c on Windows 7 Make sure you have at least 3 GB of memory on your Windows PC. Install Oracle’s JDK 7 for 64-bit OS with NetBeans and 32-bit OS when running on a 64-bit machine. Disable Microsoft’s User Access Controls (UAC). Configure your C: Windows System32 drivers etc hosts file.
During the installation, Oracle database makes some registries in windows system to store the information of its configurations as well as for proper functioning of Oracle Windows Services. To Uninstall Oracle Database 12c completely from your system you need to properly stop all the Oracle database services which run in the background.

Hardware and Software Requirements

Before installing the software, OUI performs several automated checks to ensure that your computer fulfills the basic hardware and software requirements for an Oracle Database installation. If your computer does not meet the requirements, an error message is displayed. Some of the requirements to install the software are:

Minimum 2 GB of physical memory
Sufficient virtual memory (swap)
At least 10 GB of free disk space

Prerequisites

Before starting this tutorial, you should:

Have access to the Oracle Database 12c distribution media, or have an internet connection so that you can download the software
Have general knowledge of product installation

Downloading the Oracle Database Software

In this section, you will be downloading the files required to install Oracle database on a Windows environment.

Installing Oracle 12c On Windows 8.1

Installing the Oracle Database Software

In this section, you will be installing the Oracle Database and creating an Oracle Home User account.

Verifying the Installation

In this section, you will be performing steps to verify the installation of Oracle Database. If you had changed the default location to install the database, make sure to specify the correct location of the files in the following steps. Alternatively, you can also perform a quick search using the Windows Start Menu to locate files.

View Oracle Services

View Oracle Home on the File System

View the tnsnames.ora File

Connecting to Oracle Database Using SQL*Plus

In this section, you will be connecting to the pluggable database using the SQL*Plus utility.

Summary

In this tutorial, you have learned how to:

Download the Oracle database software
Install the Oracle database software in a Windows environment
Create a database containing example schemas
Verify the database installation
Connect to an Oracle instance using the SQL*Plus utility
Unlock and query the HR schema

Resources

An Oracle White Paper entitled Introducing the Oracle Home User in Oracle Database 12c for Microsoft Windows
The documentation entitled Oracle速 Database Installation Guide 12c Release 1 (12.1) for Microsoft Windows

Credits

Lead Curriculum Developer: Supriya Ananth
Other Contributors: Christian Shay

To navigate this Oracle by Example tutorial, note the following:

Hide Header Buttons:: Click the title to hide the buttons in the header. To show the buttons again, click the title again.
Topic List:: Click a topic to navigate to that section.
Expand All Topics:: Click the button to show or hide the details for the sections. By default, all topics are collapsed.
Hide All Images:: Click the button to show or hide the screenshots. By default, all images are displayed.
Print:: Click the button to print the content. The content that is currently displayed or hidden is printed.

To navigate to a particular section in this tutorial, select the topic from the list.

Overview

At Indiana University, to download the Oracle 12c client for Windows, use either of the following methods:

Download directly from Oracle's website: This method requires a valid OTN (Oracle Technology Network) username and password. If you do not have a valid OTN username and password, visit Oracle Database Software Downloads. At the top, hover over 'Sign In', click Create an account, and then follow the on-screen instructions.
Download from IUware: This method requires a valid IU username and passphrase.

For either download method, you must be logged into your computer as an administrator.

Security of Information Technology Resources policy (IT-12) requires that you normally refrain from running your Windows computer as an administrator. For more, see About the principle of least privilege.

Download the client directly from Oracle's website

To download the Oracle client directly from Oracle's website:

Install Oracle 12c On Windows 10 Step By Step

Go to Oracle Database Software Downloads.
Under 'Oracle Database 12c Release 1', below '(12.1.0.2.0) - Enterprise Edition', to the far right of 'Microsoft Windows x64 (64-bit)', click See All.
Click OTN License Agreement, read the license agreement, and then close the window.
Select Accept License Agreement. You will see a notification thanking you for accepting the OTN License Agreement and permitting you to download the software.
Scroll down to the appropriate Oracle client for your operating system:
- 32-bit: Under 'Oracle Database Client (12.1.0.2.0) for Microsoft Windows (32-bit)', click winnt_12102_client32.zip. This file requires 826.1 MB of free space on your hard drive.
- 64-bit: Under 'Oracle Database Client (12.1.0.2.0) for Microsoft Windows (x64)', click winx64_12102_client.zip. This file requires 846.3 MB of free space on your hard drive.
You may be prompted to enter a valid OTN username and password. Once you have done so, you will see the 'File Download' dialog box. If you do not have an OTN username and password, see the instructions for getting one above.
Save the file.
In Windows, navigate to the file, right-click it, and then select Extract all.
Select a destination folder for the extracted files, and then perform the extraction.
To launch the Oracle Client Installer, go to the destination folder, open the client directory, and then double-click setup.exe (the Oracle 12c setup file).
At this point:
- Windows may prompt you for an administrator username and password. Enter an administrator username and password to proceed.
- Windows may present an 'Open File - Security Warning' dialog box. Click Run to proceed.
It may take a minute for the 'Oracle Client Installer' window to appear. To see it, you may need to minimize any other application windows that are open.

Download the client from IUware

To download the Oracle client from IUware:

Installing Oracle 12c On Windows 7 64 Bit

Go to Oracle Client 12c and select the Oracle version that corresponds to your operating system (32-bit or 64-bit).
If you see a button that says Log in for access, click it. If prompted, log in with your IU username and passphrase.
Under 'DOWNLOADS', click the .exe file listed (either Oracle 12c Client 32-bit.exe - 826.1 MB for 32-bit, or Oracle 12c Client 64-bit.exe - 853 MB for 64-bit).
In the 'File Download - Security Warning' dialog box, click Save, select a destination folder, and then click Save.
You may see a warning similar to 'Oracle 12c Client . . . is not commonly downloaded and could harm your computer.' It is safe to ignore this warning and close the dialog box.
When the download is complete, to open the IUware installer, go to the destination folder, and then double-click the Oracle .exe file you just downloaded.
You'll see an 'Open File - Security Warning' dialog box. Click Run.
A '7-Zip self-extracting archive' dialog box will open. For 'Extract to:', either accept the default (for example, c:usernameDownloads), or change to another directory to which to extract the contents of this file. Click Extract. The extraction will take a few minutes.
In the extraction directory you specified above, double-click the folder called Oracle 12c Client 32-bit or Oracle 12c Client 64-bit.
Double-click the client folder.
Double-click the setup file (of type 'Application', not 'Configuration Settings') to start the installation process.
It may take a minute for the 'Oracle Client Installer' window to appear. To see it, you may need to minimize any other application windows that are open.