Oracle DBMS_GSM_FIX
Version 19.3

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Global Service Manager Validation Utilities. The package header refers to it as "DBMS package for GWM fixed operations"
AUTHID DEFINER
Dependencies Only STANDARD
Documented Yes. Not in the TYPES and PACKAGES reference but rather in the ADMINISTRATOR'S GUIDE E49631-11
Exceptions
Error Code Reason
ORA-03770 Incorrect shard is given for replace
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to DBA and SYSDG
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfx.sql
Subprograms
 
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
 
GETDBVERSION (new 19c)
Returns the version of the current cloud database dbms_gsm_fix.getDBversion RETURN NUMBER;
SELECT dbms_gsm_fix.getDBversion
FROM dual;
 
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
 
VALIDATECDB (new 19c)
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 (new 19c overload)
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_XDB
What's New In 18cR3
What's New In 19cR3

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-2019 Daniel A. Morgan All Rights Reserved