My Oracle Support Banner

HOW TO ADD GLOBAL SERVICE IN MULTITENANT 12C DATABASE AT PDB AND ROOT LEVEL OF CDB IN A GDS ENVIRONMENT (Doc ID 2015403.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Goal

NOTE: In the images and/or the document content below, the user information and environment data used represents
fictitious data from the Oracle sample schema(s),Public Documentation delivered with an Oracle database product or
other training material. Any similarity to actual environments, actual persons, living or dead, is purely coincidental
and not intended in any manner.

For the purposes of this document, the following fictitious environment is used as an example
to describe the procedure:

REGIONS: stregion, regionora
POOLS: cdbpool
SERVICE: gdsplug, gdsplugcon
GDS Catalog database "CAT"
Multitenant Database "PLUG" with one Pluggable Database "PDB1"
NETWORK NAMES:  gdsplug.cdbpool.oradbcloud, gdsplug.cdbpool.oradbcloud

 

This article will explain how to add Global service at CDB$ROOT level and Pluggable Database Level PDB.

Multitenant container databases (CDB) can be part of the GDS configuration. A global service can be defined at root level of the CDB (CDB$ROOT) or at the pluggable database (PDB) level. A global service that runs on a PDB can be created by setting the PDB property to the PDB name at creation time. The PDB property of a global service cannot be modified once the service is created. If the PDB property is not set, the service is created at the CDB root level (CDB$ROOT).Assume below configuration already exist.

When the service is created at the PDB-level all of the service’s preferred and available databases should contain the PDB it belongs to. Global services defined at the PDB level are managed by the same operations and rules as the services defined at any other level.

Assume Below configuration already exist:

- GDS Catalog database "CAT"

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.