Creating a Global Service

To create a GDS global service, perform GDSCTL add service, modify the service for Oracle Real Application Clusters (Oracle RAC) instances, and start the service.

A global service is created by execution of the add service command. This command associates the global service with a Global Data Services pool and stores attributes of the service in the Global Data Services catalog. If databases are specified using the -preferred or -available options, then the service is created on those specified databases. If the -preferred_all option is used, then the service is created on all databases in the Global Data Services pool. For example:

GDSCTL>add service -service sales_sb -preferred_all -gdspool sales -
notification TRUE

A service that already exists in a Global Data Services pool is also automatically created on a database in the following cases:

The service is modified to add a database that is part of the pool.
The service has the -preferred_all attribute and a new database is added to the pool.

If the database is an Oracle RAC database with multiple instances, then you must modify the service to add the database instances.

GDSCTL>modify service -gdspool sales -service sales_sb -database mts -
add_instances -preferred mts1,mts2
GDSCTL>modify service -gdspool sales -service sales_sb -database stm -
add_instances -preferred stm1,stm2
GDSCTL>start service -service sales_sb -gdspool sales