Syntax

ADD DATABASE 
   DBNAME=database_name
   [ BLOCKSIZE=blocksize ]
   [ CHARSET=database_character_set ]
   [ DBLANG=database_language ]
   [ UNIQUENAME=database_unique_name ] 
   [ DBTEMPLATE=database_template ] 
   [ DBTYPE=database_type ]
   [ HOSTNAMES='host_names' ] 
   [ DATADG=data_diskgroup RECODG=reco_diskgroup ]
   [ VAULTLIST=exascale_vault_list EXASCALECLUSTER=exascale_cluster_name 
     [ STORAGETEMPLATE = exascale_storage_template_name ]]
WHERE
   { DBHOMEID=database_home_id |
     CLUSTERNUMBER=cluster_number DBHOMELOC=database_home_location |
     CLUSTERNAME=cluster_name DBHOMELOC=database_home_location |
     CLUSTERID=cluster_id DBHOMELOC=database_home_location |
     CLUSTERNUMBER=cluster_number CDBNAME=container_database_name |
     CLUSTERNAME=cluster_name CDBNAME=container_database_name |
     CLUSTERID=cluster_id CDBNAME=container_database_name }

Arguments

You can specify the following attributes for the new Oracle database:

• DBNAME : Specifies the name of the new database.

• BLOCKSIZE : Optionally, specifies the block size for the new database. The default value is 8192. This argument is not required for pluggable databases.

• CHARSET : Optionally, specifies the character set to use for the new database. The default value is AL32UTF8. This argument is not required for pluggable databases.

• DBLANG : Optionally, specifies the language to use for the new database. The default value is all_langs. This argument is not required for pluggable databases.

• UNIQUENAME : Specifies the unique name of the new database. The default value is dbname.

• DBTEMPLATE : Specifies the template to use when creating the new database, ADMIN or DW. The default value is ADMIN. This argument is not required for pluggable databases.

• DBTYPE : Optionally, specifies the type of database to create:

  • normal DB : Adds a non-container database (non-CDB). This is the default value.

  • CDB : Adds a container database.

  • PDB : Adds a pluggable database to an existing CDB.

• HOSTNAMES : Optionally, specifies a comma-separated list of host names on which the database should run. The default value is the list of nodes registered with the database home.

• DATADG : Specifies the name of the DATA disk group for the new database.

  This argument is required when adding a database using Oracle ASM storage. It does not apply to pluggable databases (PDBs) or databases using Exascale storage.

• RECODG : Specifies the name of the RECO disk group for the new database.

  This argument is required when adding a database using Oracle ASM storage. It does not apply to pluggable databases (PDBs) or databases using Exascale storage.

• VAULTLIST : Specifies a comma-separated list of Exascale vaults used to store the database.

  This argument is required when adding a database using Exascale storage. It does not apply to pluggable databases (PDBs) or databases using Oracle ASM storage.

• EXASCALECLUSTER : Specifies the name of the Exascale cluster that contains the Exascale vaults used to store the database.

  This argument is required when adding a database using Exascale storage. It does not apply to pluggable databases (PDBs) or databases using Oracle ASM storage.

• STORAGETEMPLATE : Optionally, specifes the Exascale storage template applied to the Oracle Database data files.

  You can use the OEDACLI LIST STORAGETEMPLATES command to view the list of available templates. If not specified, the default template (DATAFILE) applies.

  For example, you can specify DATA_EF_HIGHREDUNDANCY to use the built-in Exascale template that places data files on Extreme Flash (EF) storage media (if available) using high redundancy (triple mirroring).

The following arguments are available in the WHERE clause:

• DBHOMEID : Specifies the es.xml ID of the database home.

• CLUSTERNUMBER : Specifies the cluster number in the es.xml, starting at 1

• CLUSTERNAME : Specifies the name of the cluster

• CLUSTERID : Specifies the es.xml ID of the cluster

• DBHOMELOCATION : Specifies the path for the target database home.

• CDBNAME : Specifies the database name for the container database. This argument is required only when DBTYPE=PDB