runInstaller -createDatabase

The runInstaller -createDatabase command installs Oracle Database software and creates a single-instance Oracle Database on your server.

Note:

Use this command only if you have not created an Oracle home and installed the Oracle Database software on your server. If an Oracle home already exists, then create a database using Oracle DBCA.

Syntax

runInstaller -createDatabase -OSDBA sysdba_group -OSBACKUPDBA osbackup_dba_group 
-OSDGDBA os_dg_dba_group -OSKMDBA os_km_dba_group -OSRACDBA os_rac_dba_group
-ORACLE_BASE Oracle_base_dir -dataLocation data_file_location | -diskGroup ASM_disk_group_name
-gdbName database_name -pdbName pdb_name -dbSID database_SID -memoryLimit db_memory_limit_in_MB
[-executePrereqs] [-OSOPER sysoper_group] [-installEdition <EE | SE2>] [-dbType < GENERAL_PURPOSE | DATA_WAREHOUSE>]
[-enableRecovery] [-recoveryLocation recovery_file_location]] [-enableAutoMemoryManagement] [-managementOption <CLOUD_CONTROL | NONE> 
-omsHost EM_hostname -omsPort EM_port -emAdminUser EM_admin_username] [-useSamePasswordForAllSchemas] 
[-INVENTORY_LOCATION central_inventory_location] [-executeConfigTools] [-executeRootScript [-configMethod <ROOT | SUDO> [-sudoPath] [-sudoUserName]]]

Parameters

Table B-4 runInstaller -createDatabase Command Parameters

Parameter	Mandatory?	Description
`-OSDBA sysdba_group`	Yes	The name of the `SYSDBA` privileged operating system group. The default is `dba`.
`-OSBACKUPDBA osbackup_dba_group`	Yes	The name of the `SYSBACKUP` privileged operating system group.
`-OSDGDBA os_dg_dba_group`	Yes	The name of the `SYSDG` privileged operating system group.
`-OSKMDBA os_km_dba_group`	Yes	The name of the `SYSKM` privileged operating system group.
`-OSRACDBA os_rac_dba_group`	Yes	The name of the `SYSRAC` privileged operating system group.
`-ORACLE_BASE Oracle_base_dir`	Yes	Complete path to the Oracle base location to use for the Oracle Database installation.
`-dataLocation data_file_location`	Yes Mandatory, only if `-diskGroup` is not specified.	Complete path to the database file location, which is a directory for datafiles, control files, and redo logs. Note: Use this variable only if Oracle ASM is not used.
`-diskGroup ASM_disk_group_name`	Yes Mandatory, only if `-dataLocation` is not specified.	Name for the Oracle ASM disk group, for example `DATA`. Note: Use this variable only if `-dataLocation` is not used.
`-gdbName database_name`	Yes	A unique global database name for your Oracle database.
`-pdbName pdb_name`	Yes	A unique name for the pluggable database (PDB) in the container database (CDB).
`-dbSID database_SID`	Yes	A unique Oracle Service Identifier (SID) for your Oracle database.
`-memoryLimit db_memory_limit_in_MB`	Yes	Total memory allocation for the database in MB.
`-executePrereqs`	No	Run prerequisite checks to ensure that all necessary conditions and requirements are met before proceeding with the installation or configuration process.
`-OSOPER osoper_group`	No	The name of the `SYSOPER` privileged operating system group.
`-installEdition < EE \| SE2 >`	No	The installation edition of your Oracle database. The default value is `EE` for Enterprise Edition.
`-dbType <GENERAL_PURPOSE \| DATA_WAREHOUSE>`	No	The type of your Oracle database. The default value is `GENERAL_PURPOSE`.
`-enableRecovery`	No	Specify this option to enable database recovery.
`-recoveryLocation recovery_file_location`	No	Complete path to store the database recovery files.
`-enableAutoMemoryManagement`	No	Specify this option to enable automatic memory management.
`-managementOption <CLOUD_CONTROL \| NONE>`	No	Management option to use for managing the Oracle home. Default value is `NONE`.
`-omsHost EM_hostname`	No	The OMS host to connect to Enterprise Manager Cloud Control.
`-omsPort EM_port`	No	The OMS port to connect to Enterprise Manager Cloud Control.
`-emAdminUser EM_admin_username`	No	The Admin username to connect to Enterprise Manager Cloud Control.
`-useSamePasswordForAllSchemas`	No	Specify this option to use the same password for all schemas in your Oracle database.
`-INVENTORY_LOCATION central_inventory_location`	No	Complete path to the location where you want to store the inventory files. If you have previously installed an Oracle software on this computer, then specify the existing inventory path.
`-executeConfigTools`	No	Run configuration tools for an installed Oracle Database home. Note: You can use this parameter only with other commands, such as `runInstaller -createDatabase`.
`-executeRootScript`	No	Specify this option to run the root script automatically. Note: You can use this parameter only with other commands, such as `runInstaller -createDatabase`.
`-help`	No	Displays `runInstaller -createDatabase` command help.

Example

The following example shows you how to install Oracle Database software and create a single-instance Oracle Database with a CDB and a PDB:

runInstaller -createDatabase -OSDBA dba -OSBACKUPDBA backupdba -OSDGDBA dgdba -OSKMDBA kmdba -OSRACDBA racdba 
-ORACLE_BASE /u01/app/oracle -diskGroup DATA -gdbName mydb.example.com -pdbName mypdb1 -dbSID mydb -memoryLimit  24457 
-OSOPER oper -installEdition EE -enableAutoMemoryManagement -INVENTORY_LOCATION /u01/app/oraInventory 
-executeConfigTools -executeRootScript -configMethod ROOT

Parent topic: Oracle Database Installer Command-Line Options