Oracle EXADATA X6-2

3.3.3.6 DATABASE
You can add, alter, delete, or list the Oracle databases.
• ADD DATABASE (page 3-48)
• ALTER DATABASE (page 3-50)
• DELETE DATABASE (page 3-51)
• LIST DATABASES (page 3-53)
3.3.3.6.1 ADD DATABASE
This command adds an Oracle database, or a CDB or PDB to an existing CDB.
Syntax
ADD DATABASE
[ BLOCKSIZE = blocksize ]
[ CHARSET = database_character_set
DATADG = data_diskgroup
[ DBLANG = database_language ]
DBNAME = database_name
[ DBTEMPLATE = database_template ]
[ DBTYPE = database_type ]
[ HOSTNAMES = 'host_names' ]
RECODG = reco_diskgroup
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:
•
BLOCKSIZE : Specifies the block size for the new database. The default value is
8192. This argument is not required for pluggable databases.
• CHARSET : Specifies the character set to use for the new database. The default
value is AL32UTF8 . This argument is not required for pluggable databases.
• DATADG : (Mandatory) Specifies the name of the DATA disk group for the new
database. This argument is not required for pluggable databases.
• DBLANG : Specifies the language to use for the new database. The default value is
all_langs . This argument is not required for pluggable databases.
• DBNAME : (Mandatory) Specifies the name of the new database.
• 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 : Specifies the type of database to create. The accepted values are normal
DB , CDB , or PDB . The default value is normal DB .
Chapter 3
OEDA Command Line Interface
3-48