Oracle | DBMS_GSM

Oracle DBMS_GSM_FIXED Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Global Service Manager Validation Utilities. The package header refers to it as "DBMS package for GWM fixed operations"

The installation file contains the following note: "since changes to gsmadmin_internal tables aren't propagated to logical standbys, mark all GSM packages as unsupported"

AUTHID DEFINER

Constants

Name	Data Type	Value
Number of Targets
all_databases	NUMBER	0
in_payload	NUMBER	1

Data Types TYPE name_list IS TABLE OF VARCHAR2(gsmadmin_internal.dbms_gsm_common.max_ident) INDEX BY BINARY_INTEGER; TYPE connect_list IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_GSM_FIXED' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_GSM_FIXED' ORDER BY 1; Returns 74 objects

Documented Yes. Not in the TYPES and PACKAGES reference but rather in the ADMINISTRATOR'S GUIDE

Exceptions

Error Code	Reason
ORA-45568	database link to catalog is invalid

First Available 12.2

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);
PRAGMA TIMESTAMP('2014-03-14:18:43:00');

Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL and SYSDG and to the GSMADMIN_ROLE, GSMCATUSER_ROLE, GSMROOTUSER_ROLE, and GSMUSER_ROLE roles

Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfix.sql
{ORACLE_HOME}/rdbms/admin/prvtgwmfix.plb

Subprograms

CHECKCATALOGSYSLINK	GETCATALOGEP	ISGSMUP
CLEANUPDDL	GETCOLUMNINFOEX	NEW_DDL_REQUEST
DELETEBC	GETTABLESPACEDDLINTERNAL	NEW_DDL_REQUEST_PWD
ENCRYPTSYSDDL	GETBLDDL	NUMGSMUP
EXECINTERNAL	GET_FQDN	PTSHDGETSXML
EXECSQLONSHARD	GET_HOST_ADDRESS	SETCATALOGSYSLINK
EXECUTEGENERICPROCEDUREFIX	GET_HOST_NAME	SETUPBC
EXTRACTSHARDINGSCHEMAS	INCREMENTCHANGESEQ	SYNCSCHEMA
FIXBC	ISCDB	TRIMDDL
GENERATECHANGELOGENTRY	ISFEDERATEDDB	VALIDATEPARAMETERS

CHECKCATALOGSYSLINK (new 23ai)

Undocumented dbms_gsm_fixed.checkCatalogSysLink;

exec dbms_gsm_fixed.checkCatalogSysLink;

           *

      ORA-45568: database link to catalog is invalid

CLEANUPDDL (new 23ai)

Undocumented

It is not apparent why, or how, this procedure returns this exception dbms_gsm_fixed.cleanupDDL;

conn / as sysdba

      

      exec dbms_gsm_fixed.cleanupDDL;

           *

      ORA-01031: insufficient privileges

DELETEBC

Undocumented dbms_gsm_fixed.deleteBC( standby_db IN VARCHAR2, is_last_standby IN BOOLEAN, response_code OUT NUMBER, response_info OUT VARCHAR2);

TBD

ENCRYPTSYSDDL (new 23ai)

Encrypts existing DDL in ddl_requests with schema = SYS dbms_gsm_fixed.encryptSysDDL;

exec dbms_gsm_fixed.encryptSysDDL;

      

      PL/SQL procedure successfully completed.

EXECINTERNAL (new 23ai)

Undocumented dbms_gsm_fixed.execInternal( exec_id IN NUMBER, ddlid IN NUMBER, qstring IN BLOB, ignore_error IN BOOLEAN DEFAULT FALSE, curr_key IN NUMBER DFEAULT 0) ACCESSIBLE BY (PACKAGE gsmadmin_internal.dbms_gsm_dbadmin, PACKAGE gsmadmin_internal.dbms_gsm_pooladmin, PACKAGE gsmadmin_internal.dbms_gsm_common, PACKAGE gsmadmin_internal.dbms_gsm_cloudadmin, PACKAGE gsmadmin_internal.dbms_gsm_utility, PACKAGE sys.dbms_fsm_fixed, PACKAGE ggsys.ggsharding, PROCEDURE gsmadmin_internal.executeDDL, PROCEDURE gsmadmin_internal.executeCommand);

TBD

EXECSQLONSHARD (new 23ai)

Undocumented dbms_gsm_fixed.execSQLOnShard( shard_list IN gsmadmin_internal.dbms_gsm_pooladmin.name_list_type DEFAULT CAST(NULL AS gsmadmin_internal.dbms_gsm_pooladmin.name_list_type), primary_only IN NUMBER DEFAULT 0, on_catalog IN NUMBER DEFAULT 0, statement IN VARCHAR2, write_ddl_req IN NUMBER DEFAULT gsmadmi_internal.dbms_gsm_common.isTrue, sname IN VARCHAR2 DEFAULT NULL, oname IN VARCHAR2 DEFAULT NULL, istmt IN VARCHAR2 DEFAULT NULL);

TBD

EXECUTEGENERICPROCEDUREFIX

Undocumented dbms_gsm_fixed.executeGenericProcedureFix( payload IN VARCHAR2, change_type IN NUMBER, response_code OUT NUMBER, response_info OUT VARCHAR2);

TBD

EXTRACTSHARDINGSCHEMAS (new 23ai)

Undocumented dbms_gsm_fixed.extractShardingSchemas( shard_id IN NUMBER, schemas IN gsmadmin_internal.schema_list_t DEFAULT NULL);

TBD

FIXBC (23ai, 2 new parameters)

Undocumented dbms_gsm_fixed.fixBC( standby_db IN VARCHAR2, standby_conn_str IN VARCHAR2, old_db_name IN VARCHAR2, prot_mode IN NUMBER, err_num OUT NUMBER, err_string OUT VARCHAR2 primary_db IN VARCHAR2 DEFAULT NULL, primary_conn_str IN VARCHAR2 DEFAULT NULL);

TBD

GENERATECHANGELOGENTRY (new 23ai)

Undocumented dbms_gsm_fixed.generateChangeLogEntry( adminid NUMBER, changeid IN NUMBER, target IN VARCHAR2, poolname IN VARCHAR2 DEFAULT NULL, params IN VARCHAR2 DEFAULT NULL, updateRequestTable IN NUMBER DEFAULT gsmadmin_internal.dbms_gsm_utility.updateTrue, old_instances IN gsmadmin_internal.instance_list DEFAULT NULL, ddl_num IN NUMBER, DEFAULT NULL, databases IN gsmadmin_internal.number_list DEFAULT NULL, parent_id IN NUMBER DEFAULT NULL, seq_id OUT NUMBER) ACCESSIBLE BY (PACKAGE gsmadmin_internal.dbms_gsm_dbadmin, PACKAGE gsmadmin_internal.dbms_gsm_pooladmin, PACKAGE gsmadmin_internal.dbms_gsm_common, PACKAGE gsmadmin_internal.dbms_gsm_cloudadmin, PACKAGE gsmadmin_internal.dbms_gsm_utility, PACKAGE ggsys.ggsharding, PROCEDURE sys.cleanup_ddl_driver);

TBD

GETCATALOGEP (new 23ai)

Undocumented dbms_gsm_fixed.getCatalogEP RETURN VARCHAR2;

TBD

GETCOLUMNINFOEX

Undocumented dbms_gsm_fixed.getColumnInfoEx( object_owner IN VARCHAR2, object_name IN VARCHAR2, column_name IN VARCHAR2, col_type OUT NUMBER, adt_num OUT NUMBER);

TBD

GETTABLESPACEDDLINTERNAL

Undocumented dbms_gsm_fixed.getTablespaceDDLInternal( tablespaceName IN VARCHAR2, remapName IN VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;

TBD

GETBLDDL (new 23ai)

Undocumented dbms_gsm_fixed.getDblDDL( schemaname IN VARCHAR2, tablename IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_FQDN (new 23ai)

Undocumented dbms_gsm_fixed.get_fqdn(fqdn OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        exec dbms_gsm_fixed.get_fqdn(outVal);

        dbms_output.put_line(outVal);

      END;

      /

      ddmorgan-DQQ9KR3.hsd1.mn.comcast.net

      

      PL/SQL procedure successfully completed.

GET_HOST_ADDRESS (new 23ai)

Undocumented dbms_gsm_fixed.get_host_address(hostaddress OUT VARCHAR2);

TBD

GET_HOST_NAME (new 23ai)

Undocumented dbms_gsm_fixed.get_host_name(hostname OUT VARCHAR2);

TBD

INCREMENTCHANGESEQ (new 23ai)

Undocumented dbms_gsm_fixed.incrementChangeSeq RETURN NUMBER;

DECLARE

       n NUMBER;

      BEGIN

        n := dbms_gsm_fixed.incrementChangeSeq;

        dbms_output.put_line(n);

      END;

      /

      

      PLSQL procedure successfully completed.

ISCDB (new 23ai)

Checks to see if the database is container architecture

Which is really meaningless as this is new in 23ai and there is no alternative to it being a CDB dbms_gsm_fixed.isCDB RETURN BOOLEAN;

TBD

ISFEDERATEDDB (new 23ai)

Returns TRUE if federated dbms_gsm_fixed.isFederatedDB RETURN BOOLEAN;

TBD

ISGSMUP (new 23ai)

Returns true if a GSM is up dbms_gsm_fixed.isGSMUp RETURN BOOLEAN;

TBD

NEW_DDL_REQUEST (new 23ai)

Undocumented dbms_gsm_fixed.new_ddl_request( ddl_text IN CLOB, orig_ddl_text IN CLOB, schema_name IN VARCHAR2 DEFAULT NULL, object_name IN VARCHAR2 DEFAULT NULL, operation_type IN VARCHAR2, pwd_cont IN NUMBER, ddl_intcode IN NUMBER, ddl_num OUT NUMBER, ddlflag IN NUMBER DEFAULT 0, barrier_ddl IN NUMBER DEFAULT 0, syncmode IN NUMBER DEFAULT 0);

TBD

NEW_DDL_REQUEST_PWD (new 23ai)

Undocumented dbms_gsm_fixed.new_ddl_request_pwd( e_pwd IN VARCHAR2, pwd_begin IN NUMBER, ddl_num IN NUMBER, enc_key_id IN NUMBER, user_name IN VARCHAR2 DEFAULT NULL);

TBD

NUMGSMUP (new 23ai)

Returns the number of GSMs up dbms_gsm_fixed.numGSMUp RETURN NUMBER;

TBD

PTSHDGETSXML

Undocumented dbms_gsm_fixed.ptshdGetSXML( objtype IN VARCHAR2, schema_name IN VARCHAR2, objname IN VARCHAR2) RETURN CLOB;

TBD

SETCATALOGSYSLINK (new 23ai)

Undocumented dbms_gsm_fixed.setCatalogSysLink( gsmusrpwd IN VARCHAR2, gsm_endpoint IN VARCHAR2, no_check IN NUMBER DEFAULT gsmadmin_internal.dbms_gsm_common.isFalse);

TBD

SETUPBC

Undocumented dbms_gsm_fixed.setupBC( primary_db IN VARCHAR2, prim_conn_str IN VARCHAR2, prot_mode IN NUMBER, standby_dbs IN name_list, standby_conn_str IN connect_list, err_num OUT NUMBER, err_string OUT VARCHAR2);

TBD

SYNCSCHEMA

Undocumented dbms_gsm_fixed.syncSchema( schemas IN gsmadmin_internal.schema_list_t DEFAULT NULL, nversion IN NUMBER, response_code OUT NUMBER, response_info OUT VARCHAR2);

TBD

TRIMDDL (new 23ai)

Undocumented dbms_gsm_fixed.TrimDDL( ddl_id IN NUMBER, pwd_start OUT NUMBER, trim_ddl OUT VARCHAR2);

TBD

VALIDATEPARAMETERS

Undocumented dbms_gsm_fixed.validateParameters(reptype IN NUMBER);

exec dbms_gsm_fixed.validateParameters(1);

      

      PL/SQL procedure successfully completed.