{"id":263,"date":"2019-08-20T15:10:00","date_gmt":"2019-08-20T13:10:00","guid":{"rendered":"http:\/\/anjo.pt\/wp\/keyword-oracle\/?p=263"},"modified":"2019-08-20T15:10:02","modified_gmt":"2019-08-20T13:10:02","slug":"dgmgrl-error-object-a1021p_site1-was-not-found","status":"publish","type":"post","link":"https:\/\/anjo.pt\/keyword-oracle\/2019\/08\/20\/dgmgrl-error-object-a1021p_site1-was-not-found\/","title":{"rendered":"DGMGRL error: Object &#8220;a1021p_site1&#8221; was not found"},"content":{"rendered":"\n<p>While testing some scripts, I was getting an error on DGMGRL, while querying some databases:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; show database A1021P_SITE1\nObject &quot;a1021p_site1&quot; was not found\n<\/pre><\/div>\n\n\n<p>But it would work if I put single quotes around:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; show database &#039;A1021P_SITE1&#039;\n\nDatabase - A1021P_SITE1\n\n  Role:            PRIMARY\n  Intended State:  TRANSPORT-ON\n  Instance(s):\n    A1021P\n\nDatabase Status:\nSUCCESS\n<\/pre><\/div>\n\n\n<p>The problem is on the way the database was added to the configuration, and it is quite simple to fix it&#8230; <\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>after disabling configuration <\/li><li>and connecting with password to the database<\/li><li>then just rename the database to a name without using quotes.<\/li><\/ol>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nDGMGRL&gt; edit database &#039;A1021P_SITE1&#039; rename to a1021p_site1;\nError: ORA-16602: database must be disabled to perform this operation\nFailed.\n\nDGMGRL&gt; disable fast_start failover;\nDisabled.\n\nDGMGRL&gt; disable configuration\nDisabled.\n\nDGMGRL&gt; edit database &#039;A1021P_SITE1&#039; rename to a1021p_site1;\nORA-16541: database is not enabled\nConfiguration details cannot be determined by DGMGRL\n\nDGMGRL&gt; edit database &#039;A1021P_SITE1&#039; rename to a1021p_site1;\nORA-16541: database is not enabled\nConfiguration details cannot be determined by DGMGRL\n\nDGMGRL&gt; connect sys\/XXXX@a1021p_site1\nConnected.\n\nDGMGRL&gt; edit database &#039;A1021P_SITE1&#039; rename to a1021p_site1;\nSucceeded.\n\nDGMGRL&gt; show database A1021P_SITE1\n\nDatabase - a1021p_site1\n\n  Role:            PRIMARY\n  Intended State:  TRANSPORT-ON\n  Instance(s):\n    A1021P\n\nDatabase Status:\nDISABLED\n\nDGMGRL&gt; enable configuration;\nEnabled.\n\nDGMGRL&gt; enable fast_start failover\nEnabled.\n\nDGMGRL&gt; show configuration\n\nConfiguration - A1021P\n\n  Protection Mode: MaxAvailability\n  Databases:\n    a1021p_site1 - Primary database\n    a1021p_site2 - (*) Physical standby database\n\nFast-Start Failover: ENABLED\n\nConfiguration Status:\nSUCCESS\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>While testing some scripts, I was getting an error on DGMGRL, while querying some databases: But it would work if I put single quotes around: The problem is on the way the database was added to the configuration, and it is quite simple to fix it&#8230; after disabling configuration and connecting with password to the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,2,7],"tags":[],"class_list":{"0":"post-263","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dataguard","7":"category-oracle-11g","8":"category-oracle-12c","9":"czr-hentry"},"_links":{"self":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/263","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/comments?post=263"}],"version-history":[{"count":1,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/263\/revisions"}],"predecessor-version":[{"id":264,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/posts\/263\/revisions\/264"}],"wp:attachment":[{"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/media?parent=263"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/categories?post=263"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/anjo.pt\/keyword-oracle\/wp-json\/wp\/v2\/tags?post=263"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}