2.4. Creating Oracle Instance (“Launch an Instance”)

2.4.1. Sign in

With RDP, sign in as an oracle user.

2.4.2. Creating Oracle Instance (“Launch an Instance”)

This procedure describes an example on how you create an Instance. However, you do not need to configure it, based on the procedure. Please modify the details, according to the database configuration of your own.

Boot [ORACLE_HOME]¥bin¥dbca. Note: Please change the indicated words in the picture ([ORACLE_HOME]) to any suitable one for your environment.
Execute the command below in PowerShell. Please make sure to execute the PowerShell under the administrator authority.
PS C:\Windows\system32> D:\app\oraclehome\product\12.1.0\dbhome_1\bin\dbca

Select “Create Database”. Then, click “Next”.


Select “Advanced Mode”. Then, click “Next”.


Select “General Purpose or Transaction Processing”. Then, click “Next”.


After input following settings, click “Next”.

Global Database Name

Enter your own instance name (e.g. orcl).


Enter your own SID (e.g. orcl).


Mark the checkbox of the Configure Enterprise Manager (EM) Database Express, and enter your own port number (e.g. 5500) into the EM Database Express Port. Then, click [ Next ].

Mark the checkbox next to the Use the Same Administrative Password for All Accounts, and enter your own password into the Password and the Confirm Password.
Enter the orclehome OS user’s password to the Oracle Home User Password, and click [ Next ].

Check in “Create a New Listner”. After input following settings, click “Next”.

Listener Name LISTENER
Listener Port 1521
Check in “Use Database File Locations from Template”.
Mark the checkbox of the Specify Fast Recovery Area. After confirming that {ORACLE_BASE}/fast_recovery_area (optional directory) has been entered to the Fast Recovery Area, click [ Next ].
Check in “Typical Settings”
In the Memory Size (SGA and PGA), the value that is relevant to 40 % of the overall memory has been entered as default.
Click the “Sizing” tab.
Processes shows 300 as default.
Select the “Character Sets” tab.

Each item can be optionally selected; yet, in this example, click [ Connection Mode ] after the following items are entered.

National Character Set AL16UTF8 – Unicode UTF-16 Universal character set
Default Language American
Default Territory Japan

Check in “Dedicated Server Mode”, then click “Next”.

Check in “Create Database”
Check in “Save as a Database Template”. After input following settings, click “Next”.
Name Description Destination Directory

Template Name (e.g. orcl)

Description of Template

Template Store Directory (e.g. D:\\app\\oraclehome\\admin\\orcl\\scripts)


You need to verify the configuration. Click “Finish”.


Instance creation gets started.


After verifying the configuration, click “Close”