Installation and UpgradeWindows Server

How to Install Oracle Database 12.2 on Windows Server

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
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 *