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:
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 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 03
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 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 08
Oracle 12.2 OUI - Step 09
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
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 02
Oracle DBCA 12.2 - Step 03
Oracle DBCA 12.2 - Step 04
Oracle DBCA 12.2 - Step 05
Oracle DBCA 12.2 - Step 05-1
Oracle DBCA 12.2 - Step 06
Oracle DBCA 12.2 - Step 07
Oracle DBCA 12.2 - Step 08
Oracle DBCA 12.2 - Step 09
Oracle DBCA 12.2 - Step 10
Oracle DBCA 12.2 - Step 11
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 13
Oracle DBCA 12.2 - Step 14
Oracle DBCA 12.2 - Step 15
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.