oracle shard availability pending
Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in the same ORACLE_HOME. Using composite sharding method.
All the things done according to the official documentation. GDSCTL> config shows nothing wrong as I can see. but:
GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ---------- --------
ape002 shrdgrp_oper Ok Replicated reg_oper PENDING
ape003 shrdgrp_arch Ok Replicated reg_arch PENDING
In the example in the documentation the states are "Deployed" and the Availabilities are "ONLINE" and "READ_ONLY". Every time I try to redeploy I get:
GDSCTL>deploy
deploy: examining configuration...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_oper' via GSM ...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_arch' via GSM ...
deploy: shards configured successfully
GSM Warnings:
shrdgrp_oper ape002:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
shrdgrp_arch ape003:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
And in shard catalog I get:
SQL> alter session enable shard ddl;
ERROR:
ORA-02521: attempted to enable shard DDL in a non-shard database
Please tell me how to get it to work.
oracle-12c
asked Dec 20 '18 at 12:30
user10815638user10815638
63
migrated from superuser.com Dec 20 '18 at 13:19
This question came from our site for computer enthusiasts and power users.
add a comment |
Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in the same ORACLE_HOME. Using composite sharding method.
All the things done according to the official documentation. GDSCTL> config shows nothing wrong as I can see. but:
GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ---------- --------
ape002 shrdgrp_oper Ok Replicated reg_oper PENDING
ape003 shrdgrp_arch Ok Replicated reg_arch PENDING
In the example in the documentation the states are "Deployed" and the Availabilities are "ONLINE" and "READ_ONLY". Every time I try to redeploy I get:
GDSCTL>deploy
deploy: examining configuration...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_oper' via GSM ...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_arch' via GSM ...
deploy: shards configured successfully
GSM Warnings:
shrdgrp_oper ape002:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
shrdgrp_arch ape003:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
And in shard catalog I get:
SQL> alter session enable shard ddl;
ERROR:
ORA-02521: attempted to enable shard DDL in a non-shard database
Please tell me how to get it to work.
oracle-12c
asked Dec 20 '18 at 12:30
user10815638user10815638
63
migrated from superuser.com Dec 20 '18 at 13:19
This question came from our site for computer enthusiasts and power users.
add a comment |
Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in the same ORACLE_HOME. Using composite sharding method.
All the things done according to the official documentation. GDSCTL> config shows nothing wrong as I can see. but:
GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ---------- --------
ape002 shrdgrp_oper Ok Replicated reg_oper PENDING
ape003 shrdgrp_arch Ok Replicated reg_arch PENDING
In the example in the documentation the states are "Deployed" and the Availabilities are "ONLINE" and "READ_ONLY". Every time I try to redeploy I get:
GDSCTL>deploy
deploy: examining configuration...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_oper' via GSM ...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_arch' via GSM ...
deploy: shards configured successfully
GSM Warnings:
shrdgrp_oper ape002:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
shrdgrp_arch ape003:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
And in shard catalog I get:
SQL> alter session enable shard ddl;
ERROR:
ORA-02521: attempted to enable shard DDL in a non-shard database
Please tell me how to get it to work.
oracle-12c
asked Dec 20 '18 at 12:30
user10815638user10815638
63
Trying to adjust Oracle DB 12.2 sharding configuration. Have one DB as the shard catalog and other two DBs as shards. Just want to test this functionality so run the tree DBs on the same machine in the same ORACLE_HOME. Using composite sharding method.
All the things done according to the official documentation. GDSCTL> config shows nothing wrong as I can see. but:
GDSCTL>config shard
Name Shard Group Status State Region Availability
---- ----------- ------ ----- ---------- --------
ape002 shrdgrp_oper Ok Replicated reg_oper PENDING
ape003 shrdgrp_arch Ok Replicated reg_arch PENDING
In the example in the documentation the states are "Deployed" and the Availabilities are "ONLINE" and "READ_ONLY". Every time I try to redeploy I get:
GDSCTL>deploy
deploy: examining configuration...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_oper' via GSM ...
deploy: requesting chunk deployment on shards in shardgroup 'shrdgrp_arch' via GSM ...
deploy: shards configured successfully
GSM Warnings:
shrdgrp_oper ape002:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
shrdgrp_arch ape003:ORA-45598: Shard is in converted state , it should be either "PRIMARY" or "PHYSICAL STANDBY".
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3865
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3827
ORA-06512: at "GSMADMIN_INTERNAL.DBMS_GSM_DBADMIN", line 3861
ORA-06512: at line 1 (ngsmoci_execute)
And in shard catalog I get:
SQL> alter session enable shard ddl;
ERROR:
ORA-02521: attempted to enable shard DDL in a non-shard database
Please tell me how to get it to work.
oracle-12c
oracle-12c
asked Dec 20 '18 at 12:30
user10815638user10815638
63
asked Dec 20 '18 at 12:30
user10815638user10815638
63
edited Dec 20 '18 at 14:41
user10815638
asked Dec 20 '18 at 12:30
user10815638user10815638
63
asked Dec 20 '18 at 12:30
user10815638user10815638
63
asked Dec 20 '18 at 12:30
user10815638user10815638
63
63
migrated from superuser.com Dec 20 '18 at 13:19
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Dec 20 '18 at 13:19
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f225467%2foracle-shard-availability-pending%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f225467%2foracle-shard-availability-pending%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
