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 
[-recoveryLocation recovery_file_location] | -diskGroup ASM_disk_group_name [-enableRecovery]} 
-gdbName database_name -pdbName pdb_name -dbSID database_SID -memoryLimit db_memory_limit_in_MB 
[-OSOPER sysoper_group] [-installEdition <EE | SE2>] [-dbType < GENERAL_PURPOSE | DATA_WAREHOUSE>]
[-enableAutoMemoryManagement] [-managementOption <CLOUD_CONTROL | NONE> -omsHost EM_hostname 
-omsPort EM_port -emAdminUser EM_admin_username] [-executeConfigTools] 
[-executeRootScript [-configMethod <ROOT | SUDO> [-sudoPath] [-sudoUserName]]]
[-useSamePasswordForAllSchemas] [-INVENTORY_LOCATION central_inventory_location]

Parameters

Table B-4 runInstaller -createDatabase Command Parameters

Parameter	Description
`-help`	Displays `runInstaller -createDatabase` command help.
`-OSDBA`	The name of the `SYSDBA` privileged operating system group. The default is `dba`.
`-OSBACKUPDBA`	The name of the `SYSBACKUP` backup and recovery system privileges for an Oracle Database.
`-OSDGDBA`	The name of the `SYSDG` system privileges to administer and monitor Oracle Data Guard.
`-OSKMDBA`	The name of the `SYSKM` system privileges for encryption key management for applications such as Oracle Wallet Manager.
`-OSRACDBA`	The name of the `SYSRAC` privileges to perform day to day administration of Oracle databases on an Oracle RAC cluster. All Oracle Database software owners must be a member of this group.
`-OSOPER`	The name of the `SYSOPER` startup and shutdown system privileges for an Oracle Database.
`-ORACLE_BASE`	Complete path to the Oracle base location to use for the Oracle Database installation.
`-dataLocation`	Complete path to the database file location, which is a directory for datafiles, control files, and redo logs.
`-recoveryLocation`	Complete path to store the database recovery files.
`-diskGroup`	Name for the Oracle ASM disk group, for example `DATA`.
`-enableRecovery`	Specify this option to enable database recovery.
`-gdbName`	A unique global database name for your Oracle database.
`-pdbName`	A unique name for the pluggable database (PDB) in the container database (CDB).
`-dbSID`	A unique Oracle Service Identifier (SID) for your Oracle database.
`-memoryLimit`	Total memory allocation for the database in MB.
`-installEdition < EE \| SE2 >`	The installation edition of your Oracle database. The default value is `EE` for Enterprise Edition.
`-dbType <GENERAL_PURPOSE \| DATA_WAREHOUSE>`	The type of your Oracle database. The default value is `GENERAL_PURPOSE`.
`-enableAutoMemoryManagement`	Specify this option to enable automatic memory management.
`-managementOption <CLOUD_CONTROL \| NONE>`	Management option to use for managing the Oracle home. Default value is `NONE`.
`-omsHost`	The OMS host to connect to Enterprise Manager Cloud Control.
`-omsPort`	The OMS port to connect to Enterprise Manager Cloud Control.
`-emAdminUser`	The Admin username to connect to Enterprise Manager Cloud Control.
`-executeConfigTools`	Run configuration tools for an installed Oracle Database home. Note: You can use this parameter only with other commands, such as `runInstaller -createDatabase`.
`-executeRootScript`	Specify this option to run the root script automatically. Note: You can use this parameter only with other commands, such as `runInstaller -createDatabase`.
`-useSamePasswordForAllSchemas`	Specify this option to use the same password for all schemas in your Oracle database.
`-INVENTORY_LOCATION`	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.

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