Adding a Database to a Global Data Services Pool

To provide global services, a database must be added to a Global Data Services pool.

Before adding a database to a pool, the database administrator should unlock the GSMUSER account and give the password to the Global Data Services pool administrator, as shown in the following example:

ALTER USER gsmuser ACCOUNT UNLOCK;
ALTER USER gsmuser IDENTIFIED BY password;

To be part of a Global Data Services pool, a database must use a server parameter file (SPFILE). An Oracle RAC database should also have SCAN set up.

To add a database:

Connect to the Global Data Services catalog using the Global Data Services pool or Global Data Services administrator credentials, for example:
```
GDSCTL> connect rjones@catalog
```
Run the gdsctl add database command:
```
GDSCTL>add database -connect edc007:1521/db14.east.example.com -region east
 -gdspool hr
```
In this example edc007:1521/db14.east.example.com is the connect identifier of the database, and then you are prompted for the GSMUSER account password on this database.

Note:

Only add a database to a GDS pool if its Oracle release, release update (RU), or recommended release update (RUR) and and datapatch level exactly match all existing database members. Never mix newer or older database binaries. If this is done, then it can cause errors and unstable services. Also, do not add or remove databases from the pool during rolling patching or upgrades. Onboard at the matched version first, verify services, and then perform rolling patching.

If the pool already contains databases and there are global services associated with the pool, then the services are automatically created on the new database.

Use the modify database command to modify the configuration parameters of the databases in a GDS pool, such as region, connect identifier, global service manager password, SCAN address, and ONS port:

GDSCTL> modify database -database db1,db3 -region east

Use the remove database command to remove databases from a GDS pool:

GDSCTL> remove database -database db1 -gdspool pool1

Parent topic: Managing Member Databases