Search Results gsm_master_lock




Overview
Explore in AI Chat

Overview

The GSMADMIN_INTERNAL.DBMS_GSM_CLOUDADMIN package is a core infrastructure component of Oracle's Global Data Services (GDS) and Global Service Manager (GSM) framework, which ships with the Oracle database and is therefore present in every Oracle E-Business Suite 12.1.1 and 12.2.2 environment. Within the EBS context, this package provides the administrative API used to create, modify, and remove Global Service Manager catalogs, clouds, regions, database pools, subscribers, and VNCR entries. It governs the lifecycle of the GSM repository that underpins cross-database service placement, load balancing, and failover across a distributed EBS topology.

The package is owned by GSMADMIN_INTERNAL and is classified under the API category OTHER in ETRM. It is not an EBS application-owned package; it is a database-supplied PL/SQL unit whose behavior is orchestrated by the GSM control utilities. Because it manages exclusive access to the GSM master catalog, it is rarely invoked directly by EBS forms or concurrent programs, but its underlying objects frequently appear in DBA and EBS diagnostic queries — which explains why a user searching for "cloud-FC-Tasks-Latest.xlsx" (typically a GDS/GSM task tracking workbook) would land on this object.

Key Procedures and Functions

The package exposes 32 documented procedures and functions. The principal ones are:

  • GETMASTERLOCK / RELEASEMASTERLOCK — Acquire and release the exclusive GSM catalog master lock, ensuring only one GSM instance performs catalog mutations at a time.
  • CREATECATALOG / REMOVECATALOG / MODIFYCATALOG — Manage the lifecycle of the GSM catalog repository.
  • CREATECLOUD / REMOVECLOUD — Define and delete GDS clouds, the logical grouping of databases that share services.
  • ADDGSM / MODIFYGSM / REMOVEGSM / DISCONNECTGSM — Register, update, remove, or disconnect Global Service Manager instances.
  • SYNCPARAMETERS — Synchronize GDS parameters across participating GSM instances.
  • ADDVNCR / REMOVEVNCR — Manage VNCR (virtual node configuration records) used in failover scenarios.
  • CREATESUBSCRIBER / REMOVESUBSCRIBER — Add or remove subscribers to GDS services.
  • ADDREGION / MODIFYREGION / REMOVEREGION — Maintain geographic regions used for locality-aware routing.
  • ADDDATABASEPOOL — Create database pools that group databases for service placement.

Tables Accessed

This package relies heavily on Oracle-supplied database packages rather than application tables. Documented dependencies include:

  • DBMS_LOCK — provides the master lock via allocate_unique; the constant gsm_master_lock_name := 'ORA$GSM_MASTER_LOCK' identifies it.
  • DBMS_APPLICATION_INFO — sets module/action metadata for GSM sessions.
  • DBMS_AQADM, DBMS_SCHEDULER, DBMS_SERVICE, DBMS_RLS — support queue, job, service, and row-level-security configuration for the GSM catalog.
  • DBMS_ASSERT — validates SQL identifiers to guard against injection.
  • DUAL — singleton queries for lock and status evaluation.
  • GV$SESSION — identifies active GSM sessions holding locks.
  • PLITBLM and UTL_INADDR — used for internal instrumentation and host resolution.

Usage Notes

DBMS_GSM_CLOUDADMIN is invoked by GSM control utilities (gsmctl / srvctl in Grid Infrastructure) rather than by EBS-tier code. The package is referenced by 4 other packages, indicating downstream internal dependencies. For EBS administrators on 12.1.1 and 12.2.2, direct invocation is not supported and is not required for normal EBS operation; the object becomes relevant primarily when troubleshooting GDS repositories, investigating GSM lock waits, or reconciling the "cloud-FC-Tasks-Latest.xlsx" task list against active GDS configuration. Any custom scripting should be limited to read-only inspection of the documented procedures and their lock handle semantics, since forced invocation outside the GSM framework can corrupt the catalog state.