Oracle DBMS_GSM_FIX
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"
AUTHID DEFINER
Dependencies
DBMS_SYS_ERROR    
Documented Yes. Not in the TYPES and PACKAGES reference but rather in the ADMINISTRATOR'S GUIDE
Exceptions
Error Code Reason
ORA-03770 Incorrect shard is given for replace
First Available 12.2
Security Model Owned by SYS with EXECUTE granted to DBA, GSMCATUSER, GSMUSER_ROLE, and SYSDG
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfx.sql
Subprograms
 
CONFIGRMAN (new 21c)
Undocumented dbms_gsm_fix.configRMAN(
db_registered  IN  BOOLEAN,
retention      IN  BINARY_INTEGER,
pdb            IN  VARCHAR2,
device_config  IN  VARCHAR2,
channel_config IN  VARCHAR2,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(configRMAN, NONE);
TBD
 
CROSSVALIDATEDATABASE
Validate that database being replaced is the correct one by comparing input parameters with parameters for this database dbms_gsm_fix.crossValidateDatabase(
minobj_num IN NUMBER,
maxobj_num IN NUMBER,
dbid       IN NUMBER);
exec dbms_gsm_fix.crossValidateDatabase(100, 200, 1262297360);
*
ERROR at line 1:
ORA-03770: incorrect shard is given for replace:
ORA-06512: at "SYS.DBMS_GSM_FIX", line 236
ORA-06512: at line 1
 
DELETEBACKUPS (new 21c)
Undocumented dbms_gsm_fix.deleteBackups(
db_unique_name IN  VARCHAR2,
pdb            IN  VARCHAR2,
tags           IN  VARCHAR2,
obsolete       IN  BINARY_INTEGER,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(deleteBackups, NONE);
TBD
 
GETDBVERSION
Returns the version of the current cloud database dbms_gsm_fix.getDBversion RETURN NUMBER;
SELECT dbms_gsm_fix.getDBversion
FROM dual;
 
GETRMANEXITVALUE (new 21c)
Undocumented dbms_gsm_fix.getRMANExitValue(cookie IN BINARY_INTEGER) RETURN BINARY_INTEGER;
PRAGMA SUPPLEMENTAL_LOG_DATA(getRMANExitValue, NONE);
SELECT dbms_gsm_fix.getRMANExitValue(1)
FROM dual;
 
LISTBACKUPS (new 21c)
Undocumented dbms_gsm_fix.listBackups(
db_unique_name IN  VARCHAR2,
pdb            IN  VARCHAR2,
scn            IN  BINARY_INTEGER,
controlfile    IN  BINARY_INTEGER,
summary        IN  BINARY_INTEGER,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(listBackups, NONE);
TBD
 
PUTGSMUSER (new 21c)
Undocumented dbms_gsm_fix.putGSMUser(nc_pwd IN RAW);
TBD
 
READRMANOUTPUT (new 21c)
Undocumented dbms_gsm_fix.readRMANOutput(cookie IN BINARY_INTEGER) RETURN VARCHAR2;
PRAGMA SUPPLEMENTAL_LOG_DATA(readRMANOutput, NONE);
SELECT dbms_gsm_fix.readRMANOutput(1)
FROM dual;
 
RESTOREBACKUPS (new 21c)
Undocumented dbms_gsm_fix.restoreBackups(
db_unique_name IN  VARCHAR2,
pdb            IN  VARCHAR2,
scn            IN  BINARY_INTEGER,
controlfile    IN  BINARY_INTEGER,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(restoreBackups, NONE);
TBD
 
SAVEMKEY (new 21c)
Undocumented dbms_gsm_fix.saveMKey(
mkey   IN RAW,
pdb_id IN BINARY_INTEGER DEFAULT 0);
TBD
 
SENDTMPKEY (new 21c)
Undocumented dbms_gsm_fix.sendTmpKey;
SELECT dbms_gsm_fix.sendtmpkey;
 
SENDTMPKEYTOPRIM (new 21c)
Undocumented dbms_gsm_fix.setTmpKeyToPrim(
skey     IN  RAW,
skey_len IN  BINARY_INTEGER,
tkey     OUT RAW,
tkey_len OUT BINARY_INTEGER);
TBD
 
SETDGPROPERTY
Set Data Guard property in response to AQ41 or AQ42 dbms_gsm_fix.setDGProperty(
params     IN  VARCHAR2, - AQ param passed from dbms_gsm_pooladmin.setDGProperty
err_num    OUT NUMBER,
err_string OUT VARCHAR2);
TBD
 
UPDATEWALLETFORBACKUP (new 21c)
Undocumented dbms_gsm_fix.updateWalletForBackup(
rc_conn_desc IN  VARCHAR2,
rc_user      IN  VARCHAR2,
rc_pwd       IN  VARCHAR2,
db_conn_desc IN  VARCHAR2,
db_user      IN  VARCHAR2,
db_pwd       IN  VARCHAR2,
bak_tgt      IN  BINARY_INTEGER,
pdb          IN  VARCHAR2,
sdb_cat_dbid IN  VARCHAR2,
status       OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(updateWalletForBackup, NONE);
TBD
 
VALIDATEBACKUPS (new 21c)
Undocumented dbms_gsm_fix.validateBackups(
db_unique_name IN  VARCHAR2,
pdb            IN  VARCHAR2,
scn            IN  BINARY_INTEGER,
controlfile    IN  BINARY_INTEGER,
header         IN  BINARY_INTEGER,
sdb_cat_dbid   IN  VARCHAR2,
cookie         OUT BINARY_INTEGER);
PRAGMA SUPPLEMENTAL_LOG_DATA(validateBackups, NONE);
TBD
 
VALIDATECDB
Validates parameters on CDB to-be-added to configuration by user dbms_gsm_fix.validateCDB(reptype IN VARCHAR2 DEFAULT 'DG');
exec dbms_gsm_fix.validateCDB('DG');
 
VALIDATEDATABASE
Validate database existence and return local DB info

Overload 1
dbms_gsm_fix.validateDatabase(
dbpool         IN  VARCHAR2,
db_unique_name OUT VARCHAR2,
instances      OUT NUMBER,
cloud_name     IN  VARCHAR2 DEFAULT NULL);
TBD
Overload 2 dbms_gsm_fix.validateDatabase(
dbpool            IN  VARCHAR2,
db_unique_name    OUT VARCHAR2,
instances         OUT NUMBER,
cloud_name        IN  VARCHAR2 DEFAULT NULL,
hostname          OUT VARCHAR2,
agent_port        OUT NUMBER,
db_sid            OUT VARCHAR2,
oracle_home       OUT VARCHAR2,
html_port         IN  NUMBER   DEFAULT NULL,
registration_pass IN  VARCHAR2 DEFAULT NULL,
cat_host          IN  VARCHAR2 DEFAULT NULL,
dbid              OUT NUMBER,
conversion_status OUT VARCHAR2,
gg_service        IN  VARCHAR2 DEFAULT NULL,
charset           IN  VARCHAR2 DEFAULT NULL,
ncharset          IN  VARCHAR2 DEFAULT NULL);
TBD
Overload 3 dbms_gsm_fix.validateDatabase(
dbpool            IN  VARCHAR2,
db_unique_name    OUT VARCHAR2,
instances         OUT NUMBER,
cloud_name        IN  VARCHAR2 DEFAULT NULL,
hostname          OUT VARCHAR2,
agent_port        OUT NUMBER,
db_sid            OUT VARCHAR2,
oracle_home       OUT VARCHAR2,
html_port         IN  NUMBER   DEFAULT NULL,
registration_pass IN  VARCHAR2 DEFAULT NULL,
cat_host          IN  VARCHAR2 DEFAULT NULL,
dbid              OUT NUMBER,
conversion_status OUT VARCHAR2,
gg_service        IN  VARCHAR2 DEFAULT NULL,
charset           IN  VARCHAR2 DEFAULT NULL,
ncharset          IN  VARCHAR2 DEFAULT NULL,
is_cdb            IN  NUMBER   DEFAULT NULL,
pdb_name          OUT VARCHAR2,
pdb_id            OUT NUMBER);
TBD
 
VALIDATESHARD
Validate parameters on database to-be-added to configuration by user.

Note the warnings and errors. They are not just about sharding. They are a good idea in all cases.
dbms_gsm_fix.validateShard(reptype IN VARCHAR2 DEFAULT 'DG');
SQL> exec dbms_gsm_fix.validateShard('OGG');
INFO: Golden Gate shard validation requested.
INFO: Database role is PRIMARY.
INFO: Database name is ORABASE2.
INFO: Database unique name is orabase2.
INFO: Database ID is 549318987.
INFO: Database open mode is READ WRITE.
WARNING: Database not in archivelog mode.
WARNING: Flashback is off.
WARNING: Force logging is off.
INFO: Database platform is Microsoft Windows x86 64-bit.
INFO: Database character set is AL32UTF8. This value must match the character set of the catalog database.
INFO: 'compatible' initialization parameter validated successfully.
INFO: Database is a multitenant container database.
INFO: Current container is CDB$ROOT.
INFO: Database is using a server parameter file (spfile).
WARNING: db_create_file_dest is not set.
INFO: db_recovery_file_dest set to: 'C:\app2\oracle\recovery_area'
INFO: db_files=200. Must be greater than the number of chunks and/or tablespaces to be created in the shard.
INFO: remote_login_passwordfile set to EXCLUSIVE.
WARNING: db_file_name_convert is not set.
ERROR: GSMUSER account status is invalid: EXPIRED & LOCKED
ERROR: GSMADMIN_INTERNAL does not have READ privilege on DATA_PUMP_DIR.
ERROR: GSMADMIN_INTERNAL does not have WRITE privilege on DATA_PUMP_DIR.

INFO: DATA_PUMP_DIR is 'C:\app2\oracle\admin\orabase2\dpdump\'.

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
DBMS_GSM_ALERTS
DBMS_GSM_CLOUDADMIN
DBMS_GSM_COMMON
DBMS_GSM_DBADMIN
DBMS_GSM_FIXED
DBMS_GSM_NOPRIV
DBMS_GSM_POOLADMIN
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