If you use the gdsctl create shard command to create a new shard with the Database Configuration Assistant (DBCA), the GSMUSER account is automatically granted the SYSDG and SYSBACKUP privileges and assigned a random password during the deployment process. Failure to grant SYSDG and SYSBACKUP to GSMUSER on a new shard causes gdsctl add shard to fail with an ORA-1031: insufficient privileges error. The password given to the GSMUSER account is used in the gdsctl add shard command. In an Oracle Sharding configuration, the account is used to connect to shards instead of pool databases, and it must be granted both the SYSDG and SYSBACKUP system privileges after the account has been unlocked.

GSMUSER exists by default on any Oracle database. The GSMUSER account is used by GDSCTL and global service managers to connect to databases in a GDS configuration. You can manage services in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control. You can add, edit, and remove shardgroups in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control. You can add, edit, and remove shardspaces in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control. You can add, edit, and remove regions in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control. You can add, edit, and remove shard directors in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control. You can manage chunks in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control and GDSCTL. You can manage shards in your Oracle Sharding deployment with Oracle Enterprise Manager Cloud Control and GDSCTL.

Managing Sharded Database Software Versions.

When you configure system parameter settings at the shard catalog, they are automatically propagated to all shards of the sharded database. Propagation of Parameter Settings Across Shards.When making changes to duplicated tables or sharded tables in a sharded database, these changes should be done from the shard catalog database.

Backing Up and Recovering a Sharded Databaseīecause shards are hosted on individual Oracle databases, you can use Oracle Maximum Availability best practices to back up and restore shards individually.Sharded databases can be monitored using Enterprise Manager Cloud Control or GDSCTL. Managing Oracle Sharding Database Users.

Instaling WindowManager 10.10.1