add cdb

Add a cdb to the shard catalog.

Syntax

add cdb -connect connect_identifier
         [-pwd gsmrootuser_pwd]
         [-savename]
         [-cpu_threshold cpu]
         [-disk_threshold disk]
         [-rack rack_id]
         [-force]

Options

Table 2-3 GDSCTL add cdb Options

Option Description
-connect connect_identifier

Specify an Oracle Net connect descriptor or net service name that resolves to a connect descriptor for the database being added as the shard.

-pwd gsmrootuser_pwd

Enter the GSMROOTUSER password. If not specified, the user is prompted for the password.

-savename

Store in the shard catalog a net service name specified with the -connect option rather than the connect descriptor mapped to that net service name.

-force

If specified, the existing GDS and sharding configuration on the shard and in the shard catalog with information about this shard will be rewritten.

-cpu_threshold cpu

Specify the CPU Utilization percentage threshold.

-disk_threshold disk

Specify the average latency in milliseconds of a synchronous single-block read.

-rack rack_id

Specify an identifier of a rack (hardware cabinet), or another physical grouping of nodes with similar availability characteristics. If specified, GDS will enforce that databases that contain replicated data are not placed in the same rack. If this is not possible an error is raised.

Usage Notes

ADD CDB adds metadata about a CDB to a sharding catalog. This command is only necessary if you intend to deploy a PDB as a shard with the -cdb option in the ADD SHARD command. CDBs can support multiple PDB shards from different sharded databases; however, this support is limited to only one PDB shard from a given sharded database for each CDB.

Examples

Adds a CDB called db11 to the shard catalog.

GDSCTL> add cdb -connect db11 -pwd gsmrootuser_pwd