CNDBA社区
Oracle 18c Sharding ORA-03783: no new shard to deploy 问题解决方法
作者：
dave
搭建Sharding 环境中，在部署过程中提示ORA-02783的错误：
[dave@www.cndba.cn admin]$ gdsctl
GDSCTL: Version 18.0.0.0.0 - Production on Sat Oct 13 17:18:53 CST 2018
Copyright (c) 2011, 2018, Oracle. All rights reserved.
Welcome to GDSCTL, type "help" for information.
Current GSM is set to SHARDDIRECTOR
GDSCTL>
GDSCTL> deploy
deploy: examining configuration...
deploy: shards configured successfully
GSM Warnings:
CATALOG:ORA-03783: no new shard to deploy
在MOS上有个bug，可能会存在这个问题，该bug存在12.2版本，在18.1已经修复，我们测试的版本是18.1，所以不应该是这个bug：
Bug 26481301 : ORA-03783 IN RTI 20406487/20378002/20384818/20256061
进一步推测和shardgroup有关系，因为shard默认的shardgroup是standby的，即使不指定deploy_as选项，默认就是standby。
GDSCTL> add shardgroup -shardgroup standby_grp -deploy_as active_standby -region region2
```shell
在搭建环境的时候，我同时创建了2个shardgroup，一个主，一个备，但在添加shard的时候，值给主组添加了shard。如下：
```shell
[dave@www.cndba.cn admin]$ gdsctl
GDSCTL: Version 18.0.0.0.0 - Production on Sat Oct 13 17:18:53 CST 2018
Copyright (c) 2011, 2018, Oracle. All rights reserved.
Welcome to GDSCTL, type "help" for information.
Current GSM is set to SHARDDIRECTOR
GDSCTL>
GDSCTL> config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ------ ------------
sh164 primary_grp U Created region1 PENDING
sh165 primary_grp U none region1 -
sh166 primary_grp U none region1 -
GDSCTL> config shardgroup
Shard Group Chunks Region Shard space
----------- ------ ------ -----------
primary_grp 12 region1 shardspaceora
standby_grp 12 region2 shardspaceora
删除备组或者往备组添加shard，就可以正常部署了：
GDSCTL> remove shardgroup -shardgroup standby_grp
The operation completed successfully
GDSCTL> config shardgroup
Shard Group Chunks Region Shard space
----------- ------ ------ -----------
primary_grp 12 region1 shardspaceora
GDSCTL> config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ------ ------------
sh164 primary_grp U Created region1 PENDING
sh165 primary_grp U none region1 -
sh166 primary_grp U none region1 -
[dave@www.cndba.cn admin]$ gdsctl
GDSCTL: Version 18.0.0.0.0 - Production on Sat Oct 13 17:18:53 CST 2018
Copyright (c) 2011, 2018, Oracle. All rights reserved.
Welcome to GDSCTL, type "help" for information.
Current GSM is set to SHARDDIRECTOR
GDSCTL>
GDSCTL> deploy
deploy: examining configuration...
deploy: deploying primary shard 'sh164' ...
Remote job failed with error:
EXTERNAL_LOG_ID="job_75039_95",
USERNAME="oracle"
For more details:
select destination, output from all_scheduler_job_run_details
where job_name='SHARD_SH164_NETCA'
deploy: NETCA failed at destination 'shard1'
deploy: deploying primary shard 'sh165' ...
deploy: network listener configuration successful at destination 'shard2'
deploy: starting DBCA at destination 'shard2' to create primary shard 'sh165' ...
deploy: deploying primary shard 'sh166' ...
deploy: network listener configuration successful at destination 'shard3primary'
deploy: starting DBCA at destination 'shard3primary' to create primary shard 'sh166' ...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
deploy: waiting for 2 DBCA primary creation job(s) to complete...
版权声明：本文为博主原创文章，未经博主允许不得转载。
