GSMADMIN_INTERNAL, GSMCATUSER, GSMUSER

In a nutshell for the distributed environments, Unified GDS (Global Data Service) framework transparently manages client workload across replicated databases( dataguard/golden gate) oracle 12c feature.

The three schemas/users “GSMADMIN_INTERNAL, GSMCATUSER, GSMUSER” are internal Oracle users for apps that utilize GSM/GDS.

GSMADMIN_INTERNAL- The internal account that owns the Global Data Services schema. It should not be unlocked or used for a database login
GSMCATUSER -The account used by Global Service Manager to connect to the Global Data Services catalog. GSMUSER -The account used by Global Service Manager to connect to the database

gsmadmin_internal should always be in LOCK status regardless of GDS deployment.

Run the following query as SYS to verify that the schema is empty. For container databases (CDBs), this query MUST be run in CDB$ROOT and in all pluggable databases (PDBs).  

if the following query returns no rows, the GSM is not in use

select count(*) from gsmadmin_internal.cloud;

 The query output (0) confirms the Sharding is not being used in this database.
If we are not using Sharding then please we can lock the user accounts 

ALTER USER GSMADMIN_INTERNAL ACCOUNT LOCK;
ALTER USER GSMUSER ACCOUNT LOCK;
ALTER USER GSMCATUSER ACCOUNT LOCK;

 

You can change the password like you would any other user. It still needs to remain a locked user. (It is not recommended as the User is to remain Locked changing the password is unnecessary) As this user is locked changing the password should not effect operations in the Database.

When GSM in use, the new password will need to be updated in GSM catalog.

---How to change password for GSMCATUSER

   ALTER USER gsmcatuser IDENTIFIED BY xxxxxx;              ## in catalog db

   GDSCTL> modify catalog -oldpwd old_password -newpwd xxxxxx;

   GDSCTL> modify gsm -gsm gsm_name -catalog catalog_host:1524/cata_dbName -pwd xxxxxx;

---How to change password for GSMUSER

  ALTER USER gsmuser IDENTIFIED BY yyyyyy      ##in App db

  GDSCTL> modify database -database dbName -gdspool poolName -pwd yyyyyy-region regionName

---How to change password for GSMADMIN

  ALTER USER GSMADMIN IDENTIFIED BY zzzzzz     ##in Catalog db

  GDSCTL> connect gsmadmin/zzzzzz@catalog_hostname:1524/cata_dbName