Oracle^® MiniCluster S7-2 Installation Guide

Create a Database Instance

See Database Instance Overview for more information about the database instance.

1. Use the Create Database Instance page to create a database instance.
   
2. Select the template type.

   The options are:

   • DW — Creates a data warehouse type database, commonly used for analytic workloads.

   • OLTP — Creates an online transaction processing type database, commonly used for business transaction workloads.

   • Custom — If selected, you are prompted to browse to a DB template that you provide.

3. Select the database instance type.

   The options are:

   • Single — Creates a single database instance (one virtual machine) on one compute node.

   • RAC — Creates an active-active clustered database instance (two virtual machines) across both compute nodes.

   • RAC-One Node — Creates an active-passive clustered database instance (two virtual machines) across both compute nodes.

4. Select the compute node where you will create the database instance.
   • If you selected Single for the database instance type, select either compute node 1 or compute node 2.
   • If you selected RAC or RAC-One Node for the database instance type, both compute nodes are selected automatically.
5. Select the virtual machines that you will use to create the database instance.
   • If you selected Single for the database instance type, you will only be able to select a single virtual machine on the compute node that you selected in Step 4.
   • If you selected RAC or RAC-One Node for the database instance type, select two virtual machines from the two compute nodes (one from each compute node).
6. Verify the database instance version and select Yes or No for the Container Database.

   The database instance version is automatically populated based on the database home field that you selected in Step 5 of this procedure.

   The multitenant option introduced in Oracle Database 12c enables a single container database to host multiple separate pluggable databases. Choose Yes or No in the Container Database field for this option.

   If you select Yes in the Container Database field, these additional fields appear:

   • Number of PDBs — The number of pluggable databases (PDBs), between 0 and 252.

   • PDB Prefix — The prefix that is to be used to generate a unique pluggable database name, up to 8 characters (letters or numbers).

7. Type the program global area (PGA) size in MB.

   The PGA is a memory region that contains data and control information for a server process. It is a nonshared memory created by Oracle when a server process is started.

8. Type the system global area (SGA) size in MB.

   The SGA forms the part of the system memory (RAM) shared by all the processes belonging to a single Oracle database instance. The SGA contains all information necessary for the instance operation.

9. Select the character set.

   Select the character set to be set as the database character set.

10. Select the national character set.

    Select an alternate character set that enables storage of Unicode characters in a database that does not have a Unicode database character set. The options are:

    • AL16UTF16 — Unicode 3.1 UTF-16 Universal character set

    • UTF8 — Unicode 3.1 UTF-8 Universal character set

11. Type the database instance name.

    The database instance name can be up to 8 characters, and can use either letters or numbers.

12. Click the Create button.

    The Create Oracle Database Instance status page appears. The process takes roughly 75 minutes to complete.

    
    
13. When the Oracle database instance has been completed, click the Finish button.

    The Create Application Virtual Machine Group page appears. Go to Creating an Application Virtual Machine Group (Initial Installation).