{"id":11350,"date":"2018-06-17T19:51:51","date_gmt":"2018-06-17T17:51:51","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/"},"modified":"2018-06-17T19:51:51","modified_gmt":"2018-06-17T17:51:51","slug":"adwc-new-oci-interface","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/","title":{"rendered":"ADWC new OCI interface"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nA few things have changed about the Autonomous Data Warehouse Cloud service recently. And I&#8217;ve found the communication not so clear, so here is a short post about what I had to do to start the service again. The service has always been on the OCI data centers but was managed with the classic management interface. It has been recently migrated to the new interface:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\" alt=\"CaptureADWCnew\" width=\"1024\" height=\"433\" class=\"aligncenter size-large wp-image-24387\" \/><\/a><br \/>\nNote that ADWC here is the name I&#8217;ve given for my service. It seems that the Autonomous Data Warehouse Cloud Service is now referred by the ADW acronym.<br \/>\n<!--more--><\/p>\n<p>The service itself did not have any outage. The migration concerns only the interface. However, once the migration done, you cannot use the old interface. I went to the old interface with the URL I bookmarked, tried to start the service, and got a &#8216;last activity START_SERVICE failed&#8217; error message without additional detail.<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCfail1.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCfail1.png\" alt=\"CaptureADWCfail\" width=\"1024\" height=\"345\" class=\"aligncenter size-large wp-image-24431\" \/><\/a><\/p>\n<p>You can forget the old bookmark (such as https:\/\/psm-<i>tenant<\/i>.console.oraclecloud.com\/psmui\/faces\/paasRunner.jspx?serviceType=ADWC) and you now have to use the new one (such as https:\/\/console.us-ashburn-1.oraclecloud.com\/a\/db\/adws\/ocid1.autonomousdwdatabase.oc1.iad.<i>al-long-IAD-identifier<\/i>)<\/p>\n<p>So I logged to the console <a href=\"https:\/\/console.us-ashburn-1.oraclecloud.com\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/console.us-ashburn-1.oraclecloud.com<\/a> (My service is in Ashburn-1 region). There I provided the tenant name (was the cloud account in the old interface) which can also be provided in the URL as https:\/\/console.us-ashburn-1.oraclecloud.com\/?tenant=<i>tenant<\/i>. I selected oracleidentitycloudservice as the &#8216;identity provider&#8217;, my username and password and I am on the OCI console.<\/p>\n<p>From the top-left menu, I can go to Autonomous Data Warehouse. I see nothing until I choose the compartement in the &#8216;list scope&#8217;. The ADWC service I had created when in the old interface is in the &#8216;<i>tenant<\/i> (root)&#8217; compartment. Here I can start the service.<\/p>\n<p>The previous PSM command line interface cannot be used anymore. We need to install the OCI CLI:<\/p>\n<pre><code>\n$ bash -c \"$(curl -L https:\/\/raw.githubusercontent.com\/oracle\/oci-cli\/master\/scripts\/install\/install.sh)\"\n<\/code><\/pre>\n<p>You will need the Tenancy ID (Tenancy OCID:ocid1.tenancy.oc1..aaaaaaaa&#8230; that you find on the bottom of each page in the console), the User ID (User OCID ocid1.user.oc1..aaaaaaa&#8230; that you find in the &#8216;users&#8217; menu). All those &#8216;OCID&#8217; are documented in <a href=\"https:\/\/docs.us-phoenix-1.oraclecloud.com\/Content\/API\/Concepts\/apisigningkey.htm\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.us-phoenix-1.oraclecloud.com\/Content\/API\/Concepts\/apisigningkey.htm<\/a><\/p>\n<p>If you used the REST API, they change completely. You will have to post to something like:<\/p>\n<pre><code>\n\/20160918\/autonomousDataWarehouses\/ocid1.autonomousdwdatabase.oc1.iad.abuwcljrb...\/actions\/start\n<\/code><\/pre>\n<p>where the OCID is the database one that cou can copy from the console.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I&#8217;ve found the communication not so clear, so here is a short post about what I had to do to start the service again. The service has always been on the OCI data centers but was managed [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":11351,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,59],"tags":[1347,135,1375,96],"type_dbi":[],"class_list":["post-11350","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-oracle","tag-adwc","tag-cloud","tag-oci","tag-oracle"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>ADWC new OCI interface - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ADWC new OCI interface\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I&#8217;ve found the communication not so clear, so here is a short post about what I had to do to start the service again. The service has always been on the OCI data centers but was managed [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-17T17:51:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"811\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"ADWC new OCI interface\",\"datePublished\":\"2018-06-17T17:51:51+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\"},\"wordCount\":414,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\",\"keywords\":[\"ADWC\",\"Cloud\",\"OCI\",\"Oracle\"],\"articleSection\":[\"Cloud\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\",\"name\":\"ADWC new OCI interface - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\",\"datePublished\":\"2018-06-17T17:51:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png\",\"width\":1920,\"height\":811},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ADWC new OCI interface\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"ADWC new OCI interface - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/","og_locale":"en_US","og_type":"article","og_title":"ADWC new OCI interface","og_description":"By Franck Pachot . A few things have changed about the Autonomous Data Warehouse Cloud service recently. And I&#8217;ve found the communication not so clear, so here is a short post about what I had to do to start the service again. The service has always been on the OCI data centers but was managed [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/","og_site_name":"dbi Blog","article_published_time":"2018-06-17T17:51:51+00:00","og_image":[{"width":1920,"height":811,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"ADWC new OCI interface","datePublished":"2018-06-17T17:51:51+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/"},"wordCount":414,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png","keywords":["ADWC","Cloud","OCI","Oracle"],"articleSection":["Cloud","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/","url":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/","name":"ADWC new OCI interface - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png","datePublished":"2018-06-17T17:51:51+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureADWCnew.png","width":1920,"height":811},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-new-oci-interface\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ADWC new OCI interface"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11350","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11350"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11350\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11351"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11350"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}