See Database Instance Overview for more information about the database instance.
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.
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.
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).
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.
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.
Select the character set to be set as the database 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
The database instance name can be up to 8 characters, and can use either letters or numbers.
The Create Oracle Database Instance status page appears. The process takes roughly 75 minutes to complete.
The Create Application Virtual Machine Group page appears. Go to Creating an Application Virtual Machine Group (Initial Installation).