{"id":9234,"date":"2016-11-07T21:11:03","date_gmt":"2016-11-07T20:11:03","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/"},"modified":"2016-11-07T21:11:03","modified_gmt":"2016-11-07T20:11:03","slug":"oracle-public-cloud-create-a-database-from-command-line","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/","title":{"rendered":"Oracle Public Cloud: create a database from command line"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nYou love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line?<br \/>\nEasy with the CURL and REST API.<br \/>\n<!--more--><\/p>\n<h3>JSON<\/h3>\n<p>First, you need to create a JSON file with all the information for your service.<br \/>\nEverything is documented: <a href=\"https:\/\/apicatalog.oraclecloud.com\/ui\/views\/apicollection\/oracle-public\/database\/1.1\/serviceinstances\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/apicatalog.oraclecloud.com\/ui\/views\/apicollection\/oracle-public\/database\/1.1\/serviceinstances<\/a><\/p>\n<pre><code>\n$ cat createrequestbody.json\n&nbsp;\n{\n  \"description\": \"Mon Nov  7 21:03:39 CET 2016\",\n  \"edition\": \"EE_HP\",\n  \"level\": \"PAAS\",\n  \"serviceName\": \"CDB122\",\n  \"shape\": \"oc3\",\n  \"subscriptionType\": \"MONTHLY\",\n  \"version\": \"12.2.0.1\",\n  \"vmPublicKeyText\": \"ssh-dss AAAAB3NzaC1kc3MAAACBAMrw5Au0hHP1BT\/W3gcSg+Fwq36LdfzroubjS6g8RSvcaeltk1O\/uQwJV73MCsBDgs4PaAuDekZTW5w6kN8ESd6r6BGLm\/sETHNiRzOWWap3ds18iiaLJWcMbKRlZUWLdfhGemryWZaQIFrSNkfE5YkFz4V4m5d4EwKpLzIthKh3AAAAFQDtjTsaF7nydePPJPDqYERu8QlcMQAAAIBjl8NxEmE7nud7b4xuLkuJKnwlf2urHrOZGcQapNUZAjuehe6\/8VhPB4GebZb52GlyYOuELDP6e9PXyFRxTfTPff22JE5tPM8vTjCmFEKhBspl43YurJxwvDtvgTNKk5Zp5MBXMDjQ8KNHXlpnRrfh45acHI8gs0KlH51+e7j+6AAAAIA\/Q8rVC4g+MBepJGKed2ar0JzralZo7Q8vsZfQ889Y3wkaBJl2\/SRaaW1JNmkB20eZIEbRkh9e\/ex07ryKg65dgUzU4\/2dE2CSxplG0vSf\/xp7hYr\/bJzR1SZXMKbAdZ2wg+SGaTlKWAAS9xhvKGw1jVWdVgacYJOPl343bMKkuw==\",\n  \"parameters\": [\n    {\n      \"type\": \"db\",\n      \"usableStorage\": \"15\",\n      \"adminPassword\": \"P4ss#ord\",\n      \"sid\": \"CDB122\",\n      \"pdbName\": \"PDB1\",\n      \"failoverDatabase\": \"no\",\n      \"backupDestination\": \"NONE\"\n    }\n  ]\n}\n<\/code><\/pre>\n<p>You can see that you have exactly the same information as from the GUI.<\/p>\n<h3>Create Instance<\/h3>\n<p>Then, you run the following CURL command (having the cacert.pem certificate in the current directory:<\/p>\n<pre><code>\n$ curl --include --request POST --cacert .\/cacert.pem --user myuser@oracle.com:P4ss#ord --header \"X-ID-TENANT-NAME:opcoct\" --header \"Content-Type:application\/json\" --data @createrequestbody.json https:\/\/dbcs.emea.oraclecloud.com\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\n&nbsp;\nHTTP\/2 202\nserver: Oracle-Application-Server-11g\nlocation: https:\/\/dbcs.emea.oraclecloud.com:443\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/status\/create\/job\/2738110\ncontent-language: en\naccess-control-allow-origin: *\naccess-control-allow-headers: Content-Type, api_key, Authorization\nretry-after: 60\naccess-control-allow-methods: GET, POST, DELETE, PUT, OPTIONS, HEAD\nx-oracle-dms-ecid: 005GBi63mCP3n315RvWByd0003Ri0004Zg\nx-oracle-dms-ecid: 005GBi63mCP3n315RvWByd0003Ri0004Zg\nservice-uri: https:\/\/dbcs.emea.oraclecloud.com:443\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/CDB122\nx-frame-options: DENY\ncontent-type: application\/json\nvary: user-agent\ndate: Mon, 07 Nov 2016 20:03:59 GMT\n<\/code><\/pre>\n<p>Here &#8220;opcoct&#8221; is my identity domain id. You find it in the header X-ID-TENANT-NAME and the URL.<br \/>\nThe myuser@oracle.com:P4ss#ord is the user and password in the domain.<\/p>\n<p>From the GUI you can see that the creation has started:<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01.png\" alt=\"CaptureDBAASREST01\" width=\"1034\" height=\"199\" class=\"alignnone size-full wp-image-12518\" \/><\/a><\/p>\n<h3>DBaaS instance information<\/h3>\n<p>Here is the information for the database service<\/p>\n<pre><code>\n$ curl --include --request GET --cacert .\/cacert.pem --user myuser@oracle.com:P4ss#ord --header \"X-ID-TENANT-NAME:opcoct\" https:\/\/dbcs.emea.oraclecloud.com\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/CDB122\n&nbsp;\nHTTP\/2 200\nserver: Oracle-Application-Server-11g\ncontent-language: en\nservice-uri: https:\/\/dbcs.emea.oraclecloud.com:443\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/CDB122\naccess-control-allow-headers: Content-Type, api_key, Authorization\naccess-control-allow-methods: GET, POST, DELETE, PUT, OPTIONS, HEAD\nx-oracle-dms-ecid: 005GBiK7U4I3z015Rvl3id00071a0000yo\nx-oracle-dms-ecid: 005GBiK7U4I3z015Rvl3id00071a0000yo\naccess-control-allow-origin: *\nx-frame-options: DENY\ncontent-type: application\/json\nvary: user-agent\ndate: Mon, 07 Nov 2016 20:07:52 GMT\ncontent-length: 1244\n&nbsp;\n{\n  \"service_name\": \"CDB122\",\n  \"version\": \"12.2.0.1\",\n  \"status\": \"In Progress\",\n  \"description\": \"Mon Nov  7 21:03:39 CET 2016\",\n  \"identity_domain\": \"opcoct\",\n  \"creation_time\": \"2016-11-07T20:03:59.524+0000\",\n  \"last_modified_time\": \"2016-11-07T20:03:59.505+0000\",\n  \"created_by\": \"myuser@oracle.com\",\n  \"sm_plugin_version\": \"16.4.3-541\",\n  \"service_uri\": \"https:\\\/\\\/dbcs.emea.oraclecloud.com:443\\\/paas\\\/service\\\/dbcs\\\/api\\\/v1.1\\\/instances\\\/opcoct\\\/CDB122\",\n  \"num_nodes\": 1,\n  \"level\": \"PAAS\",\n  \"edition\": \"EE_HP\",\n  \"shape\": \"oc3\",\n  \"subscriptionType\": \"MONTHLY\",\n  \"creation_job_id\": \"2738110\",\n  \"num_ip_reservations\": 1,\n  \"backup_destination\": \"NONE\",\n  \"failover_database\": false,\n  \"rac_database\": false,\n  \"sid\": \"CDB122\",\n  \"pdbName\": \"PDB1\",\n  \"demoPdb\": \"\",\n  \"listenerPort\": 1521,\n  \"timezone\": \"UTC\",\n  \"is_clone\": false,\n  \"clone_supported_version\": \"16.3.1\",\n  \"active_jobs\": [\n    {\n      \"active_job_operation\": \"start-db-compute-resources\",\n      \"active_job_id\": 2738113,\n      \"active_job_messages\": []\n    },\n    {\n      \"active_job_operation\": \"create-dbaas-service\",\n      \"active_job_id\": 2738110,\n      \"active_job_messages\": []\n    }\n  ],\n  \"compute_site_name\": \"EM003_Z19\",\n  \"jaas_instances_using_service\": \"\"\n}\n<\/code><\/pre>\n<p>The status is &#8216;in progress&#8217;. Let&#8217;s look at the compute service.<\/p>\n<h3>Compute instance information<\/h3>\n<p>From the compute service, you can see if there is already an IP address assigned here<\/p>\n<pre><code>\n$ curl --include --request GET --cacert .\/cacert.pem --user myuser@oracle.com:P4ss#ord --header \"X-ID-TENANT-NAME:opcoct\" https:\/\/dbcs.emea.oraclecloud.com\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/CDB122\/servers\n&nbsp;\nHTTP\/2 200\nserver: Oracle-Application-Server-11g\ncontent-language: en\naccess-control-allow-headers: Content-Type, api_key, Authorization\naccess-control-allow-methods: GET, POST, DELETE, PUT, OPTIONS, HEAD\nx-oracle-dms-ecid: 005GBiMizXo3z015Rvl3id00071a0004p_\nx-oracle-dms-ecid: 005GBiMizXo3z015Rvl3id00071a0004p_\naccess-control-allow-origin: *\nx-frame-options: DENY\ncontent-type: application\/json\nvary: user-agent\ndate: Mon, 07 Nov 2016 20:08:35 GMT\ncontent-length: 430\n&nbsp;\n[{\n  \"status\": \"Running\",\n  \"creation_job_id\": \"2738110\",\n  \"creation_time\": \"2016-11-07T20:03:59.524+0000\",\n  \"created_by\": \"myuser@oracle.com\",\n  \"shape\": \"oc3\",\n  \"sid\": \"CDB122\",\n  \"pdbName\": \"PDB1\",\n  \"listenerPort\": 1521,\n  \"connect_descriptor\": \"CDB122:1521\\\/PDB1\",\n  \"connect_descriptor_with_public_ip\": \"null:1521\\\/PDB1\",\n  \"initialPrimary\": true,\n  \"storageAllocated\": 142336,\n  \"reservedIP\": \"\",\n  \"hostname\": \"CDB122\"\n}]\n<\/code><\/pre>\n<p>No IP address yet. I have the job id (2738110) so that I can check it later.<\/p>\n<h3>Job information<\/h3>\n<pre><code>\n$ curl --include --request GET --cacert .\/cacert.pem --user myuser@oracle.com:P4ss#ord --header \"X-ID-TENANT-NAME:opcoct\" https:\/\/dbcs.emea.oraclecloud.com\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/status\/create\/job\/2738110\n&nbsp;\nHTTP\/2 202\nserver: Oracle-Application-Server-11g\nlocation: https:\/\/dbcs.emea.oraclecloud.com:443\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/status\/create\/job\/2738110\ncontent-language: en\naccess-control-allow-origin: *\naccess-control-allow-headers: Content-Type, api_key, Authorization\nretry-after: 60\naccess-control-allow-methods: GET, POST, DELETE, PUT, OPTIONS, HEAD\nx-oracle-dms-ecid: 005GBiOeMbz3n315RvWByd0003Ri00048d\nx-oracle-dms-ecid: 005GBiOeMbz3n315RvWByd0003Ri00048d\nservice-uri: https:\/\/dbcs.emea.oraclecloud.com:443\/paas\/service\/dbcs\/api\/v1.1\/instances\/opcoct\/CDB122\nx-frame-options: DENY\ncontent-type: application\/json\nvary: user-agent\ndate: Mon, 07 Nov 2016 20:09:08 GMT\n&nbsp;\n{\n  \"service_name\": \"CDB122\",\n  \"version\": \"12.2.0.1\",\n  \"status\": \"In Progress\",\n  \"description\": \"Mon Nov  7 21:03:39 CET 2016\",\n  \"identity_domain\": \"opcoct\",\n  \"creation_time\": \"2016-11-07T20:03:59.524+0000\",\n  \"last_modified_time\": \"2016-11-07T20:03:59.505+0000\",\n  \"created_by\": \"myuser@oracle.com\",\n  \"sm_plugin_version\": \"16.4.3-541\",\n  \"service_uri\": \"https:\\\/\\\/dbcs.emea.oraclecloud.com:443\\\/paas\\\/service\\\/dbcs\\\/api\\\/v1.1\\\/instances\\\/opcoct\\\/CDB122\",\n  \"message\": [\"Starting Compute resources...\"],\n  \"job_start_date\": \"Mon Nov 07 20:04:01 GMT 2016\",\n  \"job_status\": \"InProgress\",\n  \"job_operation\": \"create-dbaas-service\",\n  \"job_request_params\": {\n    \"edition\": \"EE_HP\",\n    \"vmPublicKeyText\": \"ssh-dss AAAAB3NzaC1kc3MAAACBAMrw5Au0hHP1BT\/W3gcSg+Fwq36LdfzroubjS6g8RSvcaeltk1O\/uQwJV73MCsBDgs4PaAuDekZTW5w6kN8ESd6r6BGLm\/sETHNiRzOWWap3ds18iiaLJWcMbKRlZUWLdfhGemryWZaQIFrSNkfE5YkFz4V4m5d4EwKpLzIthKh3AAAAFQDtjTsaF7nydePPJPDqYERu8QlcMQAAAIBjl8NxEmE7nud7b4xuLkuJKnwlf2urHrOZGcQapNUZAjuehe6\/8VhPB4GebZb52GlyYOuELDP6e9PXyFRxTfTPff22JE5tPM8vTjCmFEKhBspl43YurJxwvDtvgTNKk5Zp5MBXMDjQ8KNHXlpnRrfh45acHI8gs0KlH51+e7j+6AAAAIA\/Q8rVC4g+MBepJGKed2ar0JzralZo7Q8vsZfQ889Y3wkaBJl2\/SRaaW1JNmkB20eZIEbRkh9e\/ex07ryKg65dgUzU4\/2dE2CSxplG0vSf\/xp7hYr\/bJzR1SZXMKbAdZ2wg+SGaTlKWAAS9xhvKGw1jVWdVgacYJOPl343bMKkuw==\",\n    \"count\": \"2\",\n    \"provisioningTimeout\": \"180\",\n    \"subscriptionType\": \"MONTHLY\",\n    \"createStorageContainerIfMissing\": \"false\",\n    \"dbConsolePort\": \"1158\",\n    \"listenerPort\": \"1521\",\n    \"serviceName\": \"CDB122\",\n    \"namespace\": \"dbaas\",\n    \"version\": \"12.2.0.1\",\n    \"timezone\": \"UTC\",\n    \"pdbName\": \"PDB1\",\n    \"level\": \"PAAS\",\n    \"tenant\": \"opcoct\",\n    \"serviceInstance\": \"CDB122\",\n    \"description\": \"Mon Nov  7 21:03:39 CET 2016\",\n    \"failoverDatabase\": \"false\",\n    \"emExpressPort\": \"5500\",\n    \"ncharset\": \"AL16UTF16\",\n    \"trial\": \"false\",\n    \"sid\": \"CDB122\",\n    \"noRollback\": \"false\",\n    \"operationName\": \"create-dbaas-service\",\n    \"goldenGate\": \"false\",\n    \"backupDestination\": \"NONE\",\n    \"ibkup\": \"false\",\n    \"charset\": \"AL32UTF8\",\n    \"serviceVersion\": \"12.2.0.1\",\n    \"shape\": \"oc3\",\n    \"identity_domain_id\": \"opcoct\",\n    \"serviceType\": \"dbaas\",\n    \"usableStorage\": \"15\",\n    \"disasterRecovery\": \"false\",\n    \"server_base_uri\": \"https:\\\/\\\/dbcs.emea.oraclecloud.com:443\\\/paas\\\/service\\\/dbcs\\\/\",\n    \"computeSiteName\": \"EM003_Z19\",\n    \"isRac\": \"false\"\n  }\n}\n<\/code><\/pre>\n<h3>REST Endpoint<\/h3>\n<p>Here, my test is on the EMEA datacenter and this is why the URL starts with https:\/\/dbcs.emea.oraclecloud.com<br \/>\nIf you don&#8217;t know, you can check on My Cloud Services where you have all information:<br \/>\n<a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST02.png\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST02.png\" alt=\"CaptureDBAASREST02\" width=\"1092\" height=\"385\" class=\"alignnone size-full wp-image-12522\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . You love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line? Easy with the CURL and REST API.<\/p>\n","protected":false},"author":27,"featured_media":9237,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[135,96],"type_dbi":[],"class_list":["post-9234","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-cloud","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>Oracle Public Cloud: create a database from command line - 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\/oracle-public-cloud-create-a-database-from-command-line\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Public Cloud: create a database from command line\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . You love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line? Easy with the CURL and REST API.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-11-07T20:11:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1034\" \/>\n\t<meta property=\"og:image:height\" content=\"199\" \/>\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=\"6 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\/oracle-public-cloud-create-a-database-from-command-line\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Public Cloud: create a database from command line\",\"datePublished\":\"2016-11-07T20:11:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\"},\"wordCount\":248,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png\",\"keywords\":[\"Cloud\",\"Oracle\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\",\"name\":\"Oracle Public Cloud: create a database from command line - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png\",\"datePublished\":\"2016-11-07T20:11:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png\",\"width\":1034,\"height\":199},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Public Cloud: create a database from command line\"}]},{\"@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":"Oracle Public Cloud: create a database from command line - 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\/oracle-public-cloud-create-a-database-from-command-line\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Public Cloud: create a database from command line","og_description":"By Franck Pachot . You love the Oracle Public Cloud with its simple Web interface? Great. But what if you want to automate a database creation from command line? Easy with the CURL and REST API.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/","og_site_name":"dbi Blog","article_published_time":"2016-11-07T20:11:03+00:00","og_image":[{"width":1034,"height":199,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Public Cloud: create a database from command line","datePublished":"2016-11-07T20:11:03+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/"},"wordCount":248,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png","keywords":["Cloud","Oracle"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/","name":"Oracle Public Cloud: create a database from command line - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png","datePublished":"2016-11-07T20:11:03+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/CaptureDBAASREST01-1.png","width":1034,"height":199},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-public-cloud-create-a-database-from-command-line\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Public Cloud: create a database from command line"}]},{"@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\/9234","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=9234"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9234\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/9237"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9234"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=9234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}