Managing GDS Pools

To manage GDS pools and administrators, use GDSCTL to add, modify or remove GDS pools while connected to the catalog.

Adding a Global Data Services Pool

Ensure that you are connected to the Global Data Services catalog and add a pool, administered by a specific user, as follows:

GDSCTL> add gdspool -gdspool database_pool_list [-users user_list]

If you require only one Global Data Services pool, then you do not need to add one using this example. A default Global Data Services pool, DBPOOLORA, is created for you when you create the Global Data Services catalog.

The Global Data Services administrator has permissions to run GDSCTL commands to manage a Global Data Services pool and, if there is only a single pool, then the Global Data Services administrator also administers the pool.

If you specify a user when you run the gdsctl add gdspool command, then the local DBA where the Global Data Services catalog resides must first add the user to the catalog database.

Large database clouds can require multiple Global Data Services pools that are managed by different administrators.

For example:

GDSCTL> add gdspool -gdspool hr -users rjones

The preceding example adds a Global Data Services pool called hr, and adds the user rjones, who is assigned the privileges to administer the hr pool. The privileges enable the pool administrator to add databases to the pool and manage global services on the databases in the pool.

A Global Data Services pool must have a unique name within its GDS configuration. If you do not specify a name for the pool when you create it, then the name defaults to oradbpool. The pool name can be up to 30 bytes long and can be any valid identifier (an alphabetical character followed by zero or more alphanumeric ASCII characters or the underscore (_)).

Use the modify gdspool command to modify the configuration parameters of GDS pools:

GDSCTL> modify gdspool -gdspool hr -adduser psmith

Use the remove gdspool command to remove a GDS pool(s) from the current configuration:

GDSCTL> remove gdspool -gdspool tempreaders,myfarm

Parent topic: Managing Global Data Services