Oracle | DBMS_GSM

Oracle DBMS_GSM_FIXED Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

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

ALL_SYNONYMS	DBMS_SYS_ERROR	PTSHD_SCHEMA_OBJECTS
ALL_USERS	DBMS_XMLDOM	SCHEMA_LIST_T
ATTRCOL$	DBMS_XMLPARSER	SHARD_OBJECTS
COL$	DBMS_XSLPROCESSOR	SHARD_SPACE
DBA_ROLES	DUAL	USER$
DBA_USERS	KU$_DDL	V$DATABASE
DBMS_ASSERT	KU$_DDLS	V$DG_BROKER_CONFIG
DBMS_DRS	KU$_PARSED_ITEM	V$FS_FAILOVER_OBSERVERS
DBMS_GSM_COMMON	KU$_PARSED_ITEMS	V$LOG
DBMS_GSM_DBADMIN	KU$_TABPROP_VIEW	V$PARAMETER
DBMS_GSM_UTILITY	KU$_VCNT	V$STANDBY_LOG
DBMS_LOB	OBJ$	XMLTYPE
DBMS_METADATA	PLITBLM	_CURRENT_EDITION_OBJ

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

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 GGSYS, GSMADMIN_INTERNAL, GSMROOTUSER_ROLE, GSMUSER. and SYSDG

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

Subprograms

DELETEBC	GETCOLUMNINFOEX	SETUPBC
EXECUTEGENERICPROCEDUREFIX	GETTABLESPACEDDLINTERNAL	SYNCSCHEMA
FIXBC	PTSHDGETSXML	VALIDATEPARAMETERS

DELETEBC (new 20c)

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

TBD

EXECUTEGENERICPROCEDUREFIX (new 20c)

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

TBD

FIXBC

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);

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

PTSHDGETSXML (new 20c)

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

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 (new 20c)

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

VALIDATEPARAMETERS

Undocumented dbms_gsm_fixed.validateParameters(reptype IN NUMBER);

exec dbms_gsm_fixed.validateParameters(1);