rhpctl add database

Use the rhpctl add database command to add a database using a specific working copy.

Syntax

rhpctl add database -workingcopy workingcopy_name -dbname unique_db_name
   -datafileDestination datafileDestination_path {-node node_list | -serverpool pool_name
   [-pqpool pool_name | -newpqpool pool_name -pqcardinality cardinality]
   | -newpool pool_name -cardinality cardinality [-pqpool pool_name
   | -newpqpool pool_name -pqcardinality cardinality]} [-dbtype 
   {RACONENODE | RAC | SINGLE}] [-dbtemplate file_path | image_name:relative_file_path]

Parameters

Table F-2 rhpctl add database Parameters

Parameter	Description
-workingcopy workingcopy_name	Specify the name of an existing working copy for the database that you want to add.
-dbname unique_db_name	Specify the unique name of the database (`DB_UNIQUE_NAME`) that you are adding.
-datafileDestination datafileDestination_path	Specify the data file destination location or the name of the Oracle Automatic Storage Management (Oracle ASM) disk group. Note: You cannot specify a disk group for Oracle Database versions before Oracle Database 11g release 2 (11.2).
-node node_list	Specify a node or comma-delimited list of several nodes on which to create the database.
-serverpool server_pool_name	Specify the name of an existing server pool.
-pqpool server_pool_name	Specify the name of an existing server pool. Note: This parameter is only applicable in an Oracle Flex Cluster environment and refers to server pools (either already defined, as in this case, or to be created when you use the `-newpqpool` parameter) running on Leaf Nodes.
-newpqpool server_pool_name	Optionally, you can create a new server pool to be used for parallel queries. Specify a name for the new server pool. Note: This parameter is only applicable in an Oracle Flex Cluster environment because it refers to server pools running on Leaf Nodes.
-pqcardinality cardinality	If you create a new server pool, then you must specify a cardinality value for the server pool. Note: This parameter is only applicable in an Oracle Flex Cluster environment.
-newpool server_pool_name	Optionally, you can create a new server pool. Specify a name for the new server pool.
-cardinality cardinality	If you create a new server pool, then you must specify a cardinality value for the server pool.
-dbtype {RACONENODE \| RAC \| SINGLE}	Specify whether the database is Oracle RAC One Node, Oracle RAC, or a nonclustered database.
-dbtemplate file_path \| image_name:relative_file_path	Specify the absolute file path to a database template or the relative path to the image home directory on a Rapid Home Provisioning Server.

Example

To add a database from a working copy named prodhome:

$ rhpctl add database -workingcopy prodhome -dbname proddb -datafileDestination /acfs/proddata -serverpool prodpool1 -dbtype RAC