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”.

../../_images/image0681.png

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

../../_images/image0691.png

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

../../_images/image0701.png

After input following settings, click “Next”.

Global Database Name

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

SID

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

../../_images/image0711.png

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 ].

../../_images/image0721.png
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 ].
../../_images/image0731.png

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

Listener Name LISTENER
Listener Port 1521
../../_images/image0741.png
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 ].
../../_images/image0751.png
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.
../../_images/image0761.png
Processes shows 300 as default.
Select the “Character Sets” tab.
../../_images/image0771.png

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
../../_images/image0781.png

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

../../_images/image0791.png
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)

../../_images/image0801.png

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

../../_images/image0811.png

Instance creation gets started.

../../_images/image0821.png

After verifying the configuration, click “Close”

../../_images/image0831.png