runInstaller -createDatabase
The runInstaller -createDatabase command installs Oracle AI Database software and creates a single-instance Oracle AI Database on your server.
Note:
Use this command only if you have not created an Oracle home and installed the Oracle AI 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: 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 AI 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 Note: Use this variable only if |
-gdbName database_name | Yes | A unique global database name for your Oracle AI 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 AI 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 AI Database. The default value is EE for Enterprise Edition. |
-dbType <GENERAL_PURPOSE | DATA_WAREHOUSE> | No | The type of your Oracle AI 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 AI 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 AI Database home.
|
-executeRootScript | No | Specify this option to run the root script automatically.
|
-help | No | Displays runInstaller -createDatabase command help. |
Example
The following example shows you how to install Oracle AI Database software and create a single-instance Oracle AI 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