How To Install Oracle Database 12c On Windows 10

Overview

Purpose

This tutorial shows y'all how to install the Oracle Database 12c software on Microsoft Windows forth with a default case of an Oracle Database that contains instance 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 volition start the Oracle Database Configuration Assistant (DBCA) which can install a precreated default database that contains example schemas or can guide you through the procedure of creating and configuring a customized database.

If you do not create a database during installation, you can invoke DBCA afterward you have installed the software, to create ane or more databases.

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 two GB of physical retentiveness
Sufficient virtual memory (swap)
At least 10 GB of complimentary deejay space

Prerequisites

Earlier starting this tutorial, you should:

Have access to the Oracle Database 12c distribution media, or accept an internet connection and so that you tin can download the software
Take general noesis of product installation

Downloading the Oracle Database Software

In this department, you lot will be downloading the files required to install Oracle database on a Windows surroundings.

Open a web browser of your choice and navigate to http://otn.oracle.com/windows. Past default, the page displays the **What'southward New** tab, showcasing news about Oracle on Windows.

**Note:** In this OBE, we use Net Explorer to download the software.

Click on the latest version of **Oracle Database 12c (x64)**.

The software downloads page displays the files required to download the database. It lists a set of software files to install software such as, **Oracle Database Grid Infrastructure** and **Oracle Database Gateways** with the Oracle database. Each ready displays a short clarification of what the file includes. Yous tin can cull to download whatever set up of software depending on your requirement.

In this OBE, nosotros install Oracle Database 12c. Take the license understanding and click the files under **Oracle Database 12c Release ... for Microsoft Windows (x64)** to download.

Log into your Oracle web account. If yous do not have an Oracle account, click the "Sign Up" link to create one. Then choose the location where you want to download the .zip files.

Later on downloading the files, use the default congenital-in extraction tool provided by Windows, or tools such as 7-zip to extract the `.zip` files. In this OBE, nosotros use the built-in extractor to extract the software files.

Correct click `winx64_12c_database_1of2` and select **Extract All...**

Cull the folder of your pick and click **Excerpt.** In this OBE, we excerpt the file to the `F:\windows_db_12c\ winx64_12c_database_1of2` folder.

The file `winx64_12c_database_2of2.nil` must be extracted into the same folder where the first file was extracted. Correct click `winx64_12c_database_2of2.zip` , select the **Extract All...** choice and specify the same location where the offset file was extracted. In this OBE, we extract the files to the `F:\windows_db_12c\ winx64_12c_database_1of2` folder. Click **Extract.**

The software files are extracted. Aggrandize the **`winx64_12c_database_1`** folder.

Installing the Oracle Database Software

In this department, y'all will be installing the Oracle Database and creating an Oracle Dwelling house User business relationship.

Expand the `database` folder that you extracted in the previous department. Double-click **setup**.

Click **Aye** in the User Account Control window to continue with the installation.

The **Configure Security Updates** window appears. Enter your e-mail accost and My Oracle Support password to receive security event notifications via email. If you practise not wish to receive notifications via email, deselect "**I wish to receive security updates via My Oracle Support**". Click **Next** to continue. Click "**Yeah**" in the confirmation window to confirm your preference.

The **Download Software Updates** window appears with the following options:

The **Select Installation Option** window appears with the following options:

The **Organisation Course** window appears. Select Desktop Class or Server Class depending on the type of arrangement y'all are using. In this OBE, nosotros will perform the installation on a desktop/laptop. Select **Desktop class** and click **Adjacent**.

The **Oracle Dwelling User Selection** window appears. Starting with Oracle Database 12c Release i (12.one), Oracle Database on Microsoft Windows supports the use of an Oracle Domicile User, specified at the time of installation. This Oracle Home User is used to run the Windows services for a Oracle Home, and is similar to the Oracle User on Oracle Database on Linux. This user is associated with an Oracle Home and cannot be changed to a different user mail service installation.

**Note:**

Different Oracle homes on a system can share the same Oracle Home User or employ unlike Oracle Home Users.

The Oracle Home User is unlike from an Oracle Installation User. The Oracle Installation User is the user who requires administrative privileges to install Oracle products. The Oracle Dwelling house User is used to run the Windows services for the Oracle Home.

The window provides the following options:

If you select "Utilise Existing Windows User", the user credentials provided must exist a standard Windows user account (not an administrator).

If this is a single instance database installation, the user tin can be a local user, a domain user, or a managed services account.

If this is an Oracle RAC database installation, the existing user must be a Windows domain user. The Oracle installer will display an error if this user has administrator privileges.

If yous select "Create New Windows User", the Oracle installer volition create a new standard Windows user account. This user will exist assigned as the Oracle Habitation User. Please note that this user volition not take login privileges. This option is non bachelor for an Oracle RAC Database installation.

If y'all select "Apply Windows Congenital-in Account", the system uses the Windows Built-in account equally the Oracle Dwelling User.

Select the **Create New Windows User** option. Enter the user proper noun as **OracleHomeUser1** and countersign as **Welcome1**. Click **Next**.

**Note:** Retrieve the Windows User password. Information technology volition be required later to administer or manage database services.

The **Typical Install Configuration** window appears. Click on a text field and then the balloon icon ( )to know more about the field. Note that by default, the installer creates a container database along with a pluggable database chosen "`pdborcl`". The pluggable database contains the sample `60 minutes` schema. Modify the Global database proper name to `orcl` . Enter the "Administrative password" as **Oracle_1**. This password will exist used later on to log into ambassador accounts such equally `SYS` and `SYSTEM` . Click **Next**.

The prerequisite checks are performed and a **Summary** window appears. Review the settings and click **Install**.

**Note:** Depending on your firewall settings, you may need to grant permissions to permit coffee to access the network.

The Database Configuration Assistant creates the database.

After the Database Configuration Assistant creates the database, you tin can navigate to https://localhost:5500/em every bit a `SYS` user to manage the database using Enterprise Managing director Database Express. Y'all can click "Password Management..." to unlock accounts. Click OK to continue.

The **Stop** window appears. Click **Shut** to go out the Oracle Universal Installer.

Verifying the Installation

In this section, you will exist performing steps to verify the installation of Oracle Database. If you had changed the default location to install the database, brand sure to specify the right 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

Navigate to `C:\Windows\system32` using Windows Explorer. Double-click **services**. The Services window appears, displaying a list of services.

Whorl down to view a list Oracle services. Yous see that most of the Oracle services are started successfully by the database.

View Oracle Home on the File System

Navigate to the `C:\app\OracleHomeUser1` folder. This folder contains database files (in `oradata` binder) and the Oracle Database software (in the `product` folder).

Navigate to **`C:\app\OracleHomeUser1\product\12.1.0\dbhome_1`** folder. This folder is the new "Oracle Domicile" created by the installer and contains software files related to the database.

View the tnsnames.ora File

Navigate to **`C:\app\OracleHomeUser1\product\12.ane.0\dbhome_1\NETWORK\ADMIN`** . Double-click tnsnames.ora to view the network configuration settings.

Y'all meet that a connect allonym chosen "`ORCL`" has been created. This "`ORCL`" alias points to the container database with the service name "`ORCL`".

Create a database connect alias chosen "`PDBORCL`" and specify the network configuration settings to access the pluggable database "`PDBORCL`" that we created during installation. Copy the following lawmaking and paste it in the tnsnames.ora file. If necessary, modify the host and port to match the values in the `ORCL` allonym.

`PDBORCL = (Description = (Accost = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = Defended) (SERVICE_NAME = pdborcl) ) )`

Save and close the file.

Connecting to Oracle Database Using SQL*Plus

In this section, y'all will exist connecting to the pluggable database using the SQL*Plus utility.

Open a command prompt and execute the following command. This command uses SQL*Plus to connect to the pluggable database as a arrangement ambassador:

`sqlplus sys/Oracle_1@pdborcl as sysdba;`

**Note:** If you lot had chosen a unlike administrative countersign during installation, replace `Oracle_1` with the appropriate password in the command.

By default, the `Hr` schema is locked. Execute the post-obit control to unlock the `HR` schema.

`modify user hour identified by hour business relationship unlock;`

Execute the following commands to connect to the `Hr` schema in the pluggable database and query the `EMPLOYEES` tabular array.

`connect hr/hr@pdborcl select count(*) from employees;`

The `EMPLOYEES` tabular array contains 107 rows. This verifies that the `HR` schema was created successfully when the database was installed.

Summary

In this tutorial, y'all have learned how to:

Download the Oracle database software
Install the Oracle database software in a Windows surroundings
Create a database containing case schemas
Verify the database installation
Connect to an Oracle instance using the SQL*Plus utility
Unlock and query the 60 minutes schema

Resource

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

Atomic number 82 Curriculum Programmer: Supriya Ananth
Other Contributors: Christian Shay

To navigate this Oracle by Example tutorial, annotation the post-obit:

Hide Header Buttons:: Click the title to hide the buttons in the header. To bear witness the buttons again, click the title again.
Topic List:: Click a topic to navigate to that section.
Expand All Topics:: Click the push button to prove or hibernate the details for the sections. Past default, all topics are complanate.
Hide All Images:: Click the button to testify or hide the screenshots. Past default, all images are displayed.
Print:: Click the push to print the content. The content that is currently displayed or subconscious is printed.