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

Related Topics
Built-in Functions
Built-in Packages
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_COMMON
DBMS_GSM_DBADMIN
DBMS_GSM_DDL
DBMS_GSM_FIX
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
DBMS_GSM_SEC
DBMS_GSM_UTILITY
DBMS_GSM_XDB
EXCHANGE
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx