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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |