1.4. Creating Oracle Instance (“Launch an Instance”)¶

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

1.4.1.1. Start DBCA¶

Start the DBCA with Oracle user device.

Boot “<ORACLE_HOME>/bin/dbca “. NOTE: Please modify “ORACLE_HOME”, according to your environment.

$ LANG=C /u01/app/oracle/product/12.1.0.2/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”.

“Global Database Name”：orcl

“SID” : orcl

Click “Next”.

Tick the “Configure Enterprise Manager(EM) Database Express” checkbox, as above.
“EM Database Express Port”: 5500
Click “Next”.

Tick the “Use the Same Administrative Password for All Accounts” checkbox.
“Password”: Enter in the password
“Confirm Password”: Re-enter the password
Click “Next”.

Check in “Create a New Listner”
“Listener Name” : LISTENER
“Listner Port” : 1521
Click “Next”.

Check in “Use Database File Locations from Template”.
Check in “Specify Fast Recovery Area”
“Fast Recovery Area” : {ORACLE_BASE}/fast_recovery_area
“Fast Recovery Area ” : 4560
Click “Next”.

Check in “Typical Settings”
“Memory Size(SGA and PGA)” : 3120 NOTE: This memory size, 3120 is 40% (the install default variable) of the total memory size.
Then, click the “Sizing” tab.

“Processes” : 300

Select the “Character Sets” tab, as appeared above.

Check in “Use Unicode(AL32UTF8)”
“National Character Set” ;AL16UTF8 – Unicode UTF-16 Universal character set
“Default Language” : Japanese
“Default Territory” : Japan
Then, click the “Connection Mode” tab.

Check in “Dedicated Server Mode”

Click “Next”.

Check in “Create Database”
Check in “Save as a Database Template”.
“Name” : orcl
“Description” : Optional
Check in “General Database Creation Scripts”
“Destination Directory”: /u01/app/oracle/admin/orcl/scripts
Click “Next”.

Here, you need to verify the details on the settings. Then, please click the “Finish” button.

Instance creation gets started.

After you verifying the details as above, then click “Close”. Finally, you have completely created an Instance.

1.4.2. Required Tasks After Creating an Instance.¶

1.4.2.1. Configuring the User Environment.¶

Log in as the Oracle user.

$ cd
$ vi .bash_profile

You are required to additionally write down the following. Please modify the setting contents based on your environment.

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/dbhome_1
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=orcl
export NLS_LANG=Japanese_Japan.AL32UTF8

Write down additionally, then save.

$ source .bash_profile

Verify it.

$ env | grep ORA
ORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1

Finally, you have successfully configured the Oracle related settings as described above.

1.3. Installing the Oracle Software

1.5. Verification after configuration