Skip to content

How to Install Oracle Database 12.2 on Windows

The goal in this post is to install an Oracle database 12.2 on windows server 2012. Here we separate our job into 2 major steps:

  1. Install Oracle 12.2 Software
  2. Create Oracle 12.2 Database
  3. Open Port 1521 and 5500

A. Install Oracle 12.2 Software

First of all, you must have the installation source, then click setup.exe.

Oracle Software Installation - Click setup.exe

Oracle Software Installation - Click setup.exe

Oracle 12.2 OUI - Step 01

Oracle 12.2 OUI - Step 01

In this step, we install Oracle software only and create a database later.

Oracle 12.2 OUI - Step 02

Oracle 12.2 OUI - Step 02

Oracle 12.2 OUI - Step 03

Oracle 12.2 OUI - Step 03

Oracle 12.2 OUI - Step 04

Oracle 12.2 OUI - Step 04

Even though "Use Virtual Account" is the default option, I choose "Create New Windows User" for Oracle Home User. This is the safest way to do it.

Oracle 12.2 OUI - Step 05

Oracle 12.2 OUI - Step 05

Oracle 12.2 OUI - Step 06

Oracle 12.2 OUI - Step 06

Do you see that? OUI automatically selects the new drive E other than drive C for ORACLE_BASE and ORACLE_HOME. Is it because I put the installation package of Oracle database 12.2 in drive E?

Oracle 12.2 OUI - Step 07

Oracle 12.2 OUI - Step 07

Oracle 12.2 OUI - Step 08

Oracle 12.2 OUI - Step 08

Oracle 12.2 OUI - Step 09

Oracle 12.2 OUI - Step 09

Oracle 12.2 OUI - Step 10

Oracle 12.2 OUI - Step 10

B. Create Oracle 12.2 Database

Use ⊞ Win + F to search for DBCA function, then click it.

Search for DBCA on Windows Server

Search for DBCA on Windows Server

Please note that, don't use CMD to call DBCA, it will fail later.

Oracle DBCA 12.2 - Step 01

Oracle DBCA 12.2 - Step 01

Oracle DBCA 12.2 - Step 02

Oracle DBCA 12.2 - Step 02

Oracle DBCA 12.2 - Step 03

Oracle DBCA 12.2 - Step 03

Oracle DBCA 12.2 - Step 04

Oracle DBCA 12.2 - Step 04

Oracle DBCA 12.2 - Step 05

Oracle DBCA 12.2 - Step 05

Oracle DBCA 12.2 - Step 05-1

Oracle DBCA 12.2 - Step 05-1

Oracle DBCA 12.2 - Step 06

Oracle DBCA 12.2 - Step 06

Oracle DBCA 12.2 - Step 07

Oracle DBCA 12.2 - Step 07

Oracle DBCA 12.2 - Step 08

Oracle DBCA 12.2 - Step 08

Oracle DBCA 12.2 - Step 09

Oracle DBCA 12.2 - Step 09

Oracle DBCA 12.2 - Step 10

Oracle DBCA 12.2 - Step 10

Oracle DBCA 12.2 - Step 11

Oracle DBCA 12.2 - Step 11

Oracle DBCA 12.2 - Step 12

Oracle DBCA 12.2 - Step 12

Click Customize Storage Locations... to change the size of redo logs.

Oracle DBCA 12.2 - Step 12-1

Oracle DBCA 12.2 - Step 12-1

Oracle DBCA 12.2 - Step 13

Oracle DBCA 12.2 - Step 13

Oracle DBCA 12.2 - Step 14

Oracle DBCA 12.2 - Step 14

Oracle DBCA 12.2 - Step 15

Oracle DBCA 12.2 - Step 15

Check Oracle Services on Windows Server

Check Oracle Services on Windows Server

Open Port 1521 and 5500

One last move is to open port 1521 for your incoming connections on windows server.

Leave a Reply

Your email address will not be published. Required fields are marked *