{"id":11167,"date":"2018-05-02T04:10:19","date_gmt":"2018-05-02T02:10:19","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/"},"modified":"2018-05-02T04:10:19","modified_gmt":"2018-05-02T02:10:19","slug":"adwc-startstop-with-psm-command-line-interface","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/","title":{"rendered":"ADWC:  start\/stop with PSM Command Line Interface"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nIn the <a href=\"https:\/\/www.dbi-services.com\/blog\/adwc-creation-of-autonomous-database-cloud-service\" target=\"_blank\" rel=\"noopener noreferrer\">previous post<\/a>, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is starting and stopping the service. This is the best way to save credits for hourly billed services. And PSM is the easiest: run from everywhere (it is Python 3) and no need to provide credentials each time. In the previous post, I explained how to setup PSM for the ADWC service.<\/p>\n<p>Unfortunately, for starting and stopping the instance you may realize that:<\/p>\n<ul>\n<li>It is not in the documentation<\/li>\n<li>Syntax exists but doesn&#8217;t work<\/li>\n<\/ul>\n<p><!--more--><br \/>\nThe documentation is there, but no mention of start-service, stop-service nor restart-service: <a href=\"https:\/\/docs.oracle.com\/en\/cloud\/paas\/autonomous-data-warehouse-cloud\/user\/adwc-commands.html\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/docs.oracle.com\/en\/cloud\/paas\/autonomous-data-warehouse-cloud\/user\/adwc-commands.html<\/a><\/p>\n<p>The online help has start\/stop\/restart-service:<\/p>\n<pre><code>\n$ psm adwc h\n&nbsp;\nDESCRIPTION\n  Oracle Autonomous Data Warehouse Cloud\n&nbsp;\nSYNOPSIS\n  psm ADWC  [parameters]\n&nbsp;\nAVAILABLE COMMANDS\n  o services\n       List all Autonomous Data Warehouse Cloud instances\n  o service\n       List Autonomous Data Warehouse Cloud instance\n  o create-service\n       Provision Autonomous Data Warehouse\n  o delete-service\n       Unprovision Autonomous Data Warehouse\n  o scale-service\n       Scale Autonomous Data Warehouse\n  o start-service\n       This operation will set the operational state of service as started\n  o stop-service\n       This operation will set the operational state of service as stopped\n  o restart-service\n       This operation will set the operational state of service as after...\n  o view-backups\n       List all backups of Autonomous Data Warehouse Cloud instance\n  o view-backup\n       List a backup of Autonomous Data Warehouse Cloud instance\n  o backup\n       Backup Autonomous Data Warehouse\n  o view-restores\n       List all restore operations for Autonomous Data Warehouse Cloud instance\n  o view-restore\n       List a specified restore operation for Autonomous Data Warehouse Cloud...\n  o restore\n       Restore Autonomous Data Warehouse\n  o check-health\n       Health Check operation\n  o operation-status\n       View status of Autonomous Data Warehouse Cloud instance operation\n  o activities\n       View activities for Autonomous Data Warehouse Cloud instance\n  o help\n       Show help\n<\/code><\/pre>\n<p>All 3 take the same parameters, the service name, the REST API output format, and a boolean for wait of the completion of the job:<\/p>\n<pre><code>\n$ psm adwc start-service h\n&nbsp;\nDESCRIPTION\n  This operation will set the operational state of service as started\n&nbsp;\nSYNOPSIS\n  psm ADWC start-service [parameters]\n       -s, --service-name \n       [-of, --output-format ]\n       [-wc, --wait-until-complete ]\n&nbsp;\nAVAILABLE PARAMETERS\n  -s, --service-name    (string)\n       Name of the Autonomous Data Warehouse Cloud instance\n&nbsp;\n  -of, --output-format    (string)\n       Desired output format. Valid values are [short, json, html]\n&nbsp;\n  -wc, --wait-until-complete  (boolean)\n       Wait until the command is complete. Valid values are [true, false]. Default is\n       'false'.\n&nbsp;\nEXAMPLES\n  psm ADWC start-service -s ExampleInstance\n<\/code><\/pre>\n<h3>But&#8230;<\/h3>\n<p>So, the online help show it and I try it:<\/p>\n<pre><code>\n$ psm adwc start-service --service-name ADWC --output-format short -wc true\n&nbsp;\nError: Not Found. &lt;!DOCTYPE HTML PUBLIC \"-\/\/W3C\/\/DTD HTML 4.0 Draft\/\/EN\"&gt;\n&lt;HTML&gt;\n&lt;HEAD&gt;\n&lt;TITLE&gt;Error 404--Not Found&lt;\/TITLE&gt;\n&lt;\/HEAD&gt;\n&lt;BODY bgcolor=\"white\"&gt;\n&lt;FONT FACE=Helvetica&gt;&lt;BR CLEAR=all&gt;\n&lt;TABLE border=0 cellspacing=5&gt;&lt;TR&gt;&lt;TD&gt;&lt;BR CLEAR=all&gt;\n&lt;FONT FACE=\"Helvetica\" COLOR=\"black\" SIZE=\"3\"&gt;&lt;H2&gt;Error 404--Not Found&lt;\/H2&gt;\n&lt;\/FONT&gt;&lt;\/TD&gt;&lt;\/TR&gt;\n&lt;\/TABLE&gt;\n&lt;TABLE border=0 width=100% cellpadding=10&gt;&lt;TR&gt;&lt;TD VALIGN=top WIDTH=100% BGCOLOR=white&gt;&lt;FONT FACE=\"Courier New\"&gt;&lt;FONT FACE=\"Helvetica\" SIZE=\"3\"&gt;&lt;H3&gt;From RFC 2068 &lt;i&gt;Hypertext Transfer Protocol -- HTTP\/1.1&lt;\/i&gt;:&lt;\/H3&gt;\n&lt;\/FONT&gt;&lt;FONT FACE=\"Helvetica\" SIZE=\"3\"&gt;&lt;H4&gt;10.4.5 404 Not Found&lt;\/H4&gt;\n&lt;\/FONT&gt;&lt;P&gt;&lt;FONT FACE=\"Courier New\"&gt;The server has not found anything matching the Request-URI. No indication is given of whether the condition is temporary or permanent.&lt;\/p&gt;&lt;p&gt;If the server does not wish to make this information available to the client, the status code 403 (Forbidden) can be used instead. The 410 (Gone) status code SHOULD be used if the server knows, through some internally configurable mechanism, that an old resource is permanently unavailable and has no forwarding address.&lt;\/FONT&gt;&lt;\/P&gt;\n&lt;\/FONT&gt;&lt;\/TD&gt;&lt;\/TR&gt;\n&lt;\/TABLE&gt;\n&nbsp;\n&lt;\/BODY&gt;\n&lt;\/HTML&gt;\n<\/code><\/pre>\n<p>Unfortunately, this doesn&#8217;t work. Is it that those commands are not supported yet, reason why we don&#8217;t find them in the documentation? Or maybe the opposite: they do not work and rather than fix them, they removed them from the documentation. One thing I&#8217;m 100% sure: start-service and stop-service are the most useful commands for a CLI giving easy access to an hourly billed and I want them to work. And it is Python, JSON and HTML &#8211; nothing hidden there.<\/p>\n<h3><del>Hack<\/del> Fix<\/h3>\n<p>The error message is about no matching URL. PSM metadata is stored in your user directory (~\/.psm\/data on Linux) with one JSON file for each Oracle platform service. Having a look at the URLs in ADWC.json the bug is obvious:<\/p>\n<pre><code>\n$ jq . ~\/.psm\/data\/ADWC.json | grep uri\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/scale\",\n        \"uri\": \"\/paas\/core\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/start\",\n        \"uri\": \"\/paas\/core\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/stop\",\n        \"uri\": \"\/paas\/core\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/restart\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/backups\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/backups\/{backupId}\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/backups\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/restoredbackups\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/restoredbackups\/{jobId}\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/restoredbackups\",\n        \"uri\": \"\/paas\/api\/v1.1\/instancemgmt\/{identityDomainId}\/services\/{serviceType}\/instances\/{serviceName}\/healthcheck\",\n        \"uri\": \"\/paas\/api\/v1.1\/activitylog\/{identityDomainId}\/job\/{jobId}\",\n        \"uri\": \"\/paas\/api\/v1.1\/activitylog\/{identityDomainId}\/filter\",\n<\/code><\/pre>\n<p>Let&#8217;s remove this &#8216;\/core&#8217; from the uri:<\/p>\n<pre><code>\nsed -ie 's\/core\\\\[\/]\/\/g' ~\/.psm\/data\/ADWC.json\n<\/code><\/pre>\n<p>And run again the start-service:<\/p>\n<pre><code>\n$ psm adwc start-service -s ADWC -wc true\n&nbsp;\n Message:    Job submitted successfully for start of service\/system\n Job ID:     25617877\nWaiting for the job to complete... (it cannot be cancelled)\n<\/code><\/pre>\n<p>Here it is.<\/p>\n<p>As my laptop is on Windows where I use Cygwin, I have setup two icons with:<\/p>\n<pre><code>C:\\cygwin64\\bin\\mintty.exe -w min \/usr\/bin\/psm adwc stop-service -s ADWC -wc true\nC:\\cygwin64\\bin\\mintty.exe -w min \/usr\/bin\/psm adwc start-service -s ADWC -wc true<\/code><\/pre>\n<h3>Start\/Stop time<\/h3>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\" alt=\"CaptureStartStop\" width=\"300\" height=\"150\" class=\"alignright size-medium wp-image-22874\" \/><\/a><br \/>\nThis ADWC service is a PDBaaS. Starting and Stopping is as easy as opening and closing a pluggable database. Here are the timestamps after starting and stoppin in a loop (with graph on 24 loops).<\/p>\n<p>The startup time is around 30 seconds. The stop time is about a minute. Really easy to use.<\/p>\n<pre><code>\n$ psm adwc activities -s ADWC -l 50\n Operation Type  Status   Start Time                    End Time\n START_SERVICE   SUCCEED  2018-04-29T14:30:36.888+0000  2018-04-29T14:31:21.563+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:27:26.551+0000  2018-04-29T14:27:35.610+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:25:22.172+0000  2018-04-29T14:25:51.586+0000\n START_SERVICE   SUCCEED  2018-04-29T14:20:47.957+0000  2018-04-29T14:21:38.131+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:08:09.409+0000  2018-04-29T14:08:48.125+0000\n START_SERVICE   SUCCEED  2018-04-29T14:07:24.892+0000  2018-04-29T14:08:08.244+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:04:57.566+0000  2018-04-29T14:05:27.458+0000\n START_SERVICE   SUCCEED  2018-04-29T14:03:51.035+0000  2018-04-29T14:04:34.108+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:03:17.701+0000  2018-04-29T14:03:47.262+0000\n START_SERVICE   SUCCEED  2018-04-29T14:02:00.944+0000  2018-04-29T14:02:50.978+0000\n STOP_SERVICE    SUCCEED  2018-04-29T14:00:56.990+0000  2018-04-29T14:01:29.567+0000\n START_SERVICE   SUCCEED  2018-04-29T13:59:52.898+0000  2018-04-29T14:00:39.373+0000\n STOP_SERVICE    SUCCEED  2018-04-29T13:59:19.380+0000  2018-04-29T13:59:49.011+0000\n START_SERVICE   SUCCEED  2018-04-29T13:58:15.594+0000  2018-04-29T13:58:58.937+0000\n STOP_SERVICE    SUCCEED  2018-04-29T13:57:42.355+0000  2018-04-29T13:58:11.845+0000\n...\n<\/code><\/pre>\n<p>Easy command line without having to provide a password interactively, wait for completion, fast operation, this gives a great user experience for this service. The only problem is when you play with several cloud accounts. I&#8217;ll show an idea in the next post.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is starting and stopping the service. This is the best way to save credits for hourly billed services. And PSM [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":11168,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[1347,1191,135,96,1184],"type_dbi":[],"class_list":["post-11167","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-adwc","tag-autonomous","tag-cloud","tag-oracle","tag-oracle-18c"],"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: start\/stop with PSM Command Line 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-startstop-with-psm-command-line-interface\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ADWC: start\/stop with PSM Command Line Interface\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is starting and stopping the service. This is the best way to save credits for hourly billed services. And PSM [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-02T02:10:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1015\" \/>\n\t<meta property=\"og:image:height\" content=\"506\" \/>\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=\"7 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-startstop-with-psm-command-line-interface\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"ADWC: start\/stop with PSM Command Line Interface\",\"datePublished\":\"2018-05-02T02:10:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\"},\"wordCount\":438,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\",\"keywords\":[\"ADWC\",\"Autonomous\",\"Cloud\",\"Oracle\",\"Oracle 18c\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\",\"name\":\"ADWC: start\/stop with PSM Command Line Interface - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\",\"datePublished\":\"2018-05-02T02:10:19+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png\",\"width\":1015,\"height\":506},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ADWC: start\/stop with PSM Command Line 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: start\/stop with PSM Command Line 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-startstop-with-psm-command-line-interface\/","og_locale":"en_US","og_type":"article","og_title":"ADWC: start\/stop with PSM Command Line Interface","og_description":"By Franck Pachot . In the previous post, I explained how to create an Autonomous Data Warehouse with PSM (PaaS Service Manager Command Line Interface). The most common operation you want to do with it is starting and stopping the service. This is the best way to save credits for hourly billed services. And PSM [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/","og_site_name":"dbi Blog","article_published_time":"2018-05-02T02:10:19+00:00","og_image":[{"width":1015,"height":506,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"ADWC: start\/stop with PSM Command Line Interface","datePublished":"2018-05-02T02:10:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/"},"wordCount":438,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png","keywords":["ADWC","Autonomous","Cloud","Oracle","Oracle 18c"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/","url":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/","name":"ADWC: start\/stop with PSM Command Line Interface - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png","datePublished":"2018-05-02T02:10:19+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureStartStop.png","width":1015,"height":506},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/adwc-startstop-with-psm-command-line-interface\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"ADWC: start\/stop with PSM Command Line 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\/11167","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=11167"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11167\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/11168"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11167"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}