Oracle DBMS_GSM_FIX
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
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
First Available 12.2.0.1
Security Model Owned by SYS with EXECUTE granted to DBA, GGSYS, and SYSDG
Source {ORACLE_HOME}/rdbms/admin/dbmsgwmfx.sql
Subprograms
VALIDATE_DATABASE VALIDATE_SHARD  
 
VALIDATEDATABASE (new 12.2)
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
 
VALIDATESHARD (new 12.2)
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 12cR1
What's New In 12cR2

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