{"id":1782,"date":"2016-11-08T20:47:17","date_gmt":"2016-11-09T02:47:17","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1782"},"modified":"2026-02-07T15:27:15","modified_gmt":"2026-02-07T21:27:15","slug":"exploring-oracle-cloud-dbaas-the-start","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1782\/","title":{"rendered":"Exploring #Oracle #Cloud #DBaaS &#8211; The Start!"},"content":{"rendered":"<p>Got excited to see Oracle Database 12.2 available on Oracle Cloud DBaaS, and wanted to try it out immediately. This blog is my first experience, and I will continue sharing as I learn Oracle DBaaS myself!<\/p>\n<p>Oracle has provided an excellent step by step quick start document. Though the document is not updated with 12.2 offering, it is pretty good to get started, and hopefully, by the time you read this blog, the updated content would be available.<\/p>\n<p>Reference:\u00a0<a href=\"http:\/\/www.oracle.com\/webfolder\/technetwork\/tutorials\/obe\/cloud\/dbaas\/obe_dbaas_QS\/oracle_database_cloud_service_dbaas_quick_start.html#section7\">Oracle Database Cloud &#8211; Database as a Service Quick Start<\/a><\/p>\n<p>I followed the steps as is for the following sections in the document:<\/p>\n<ul>\n<li>Create SSH Private and Public Keys<\/li>\n<li>Creating a Service Instance\n<ul>\n<li>Invoking the Create Database Cloud Service Wizard<\/li>\n<li>Defining the Subscription Type<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>The next section is &#8220;Selecting the Software Release&#8221;, here I picked the latest and greatest.<\/p>\n<p id=\"htjCgyT\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1784 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822800f4d273.png?resize=537%2C350&#038;ssl=1\" alt=\"\" width=\"537\" height=\"350\" \/><\/p>\n<p>No specific reason why I chose &#8220;High Performance&#8221; in the next screen, it looked good \ud83d\ude42<\/p>\n<p id=\"bqJcQQN\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1785 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228122503ca.png?resize=547%2C422&#038;ssl=1\" alt=\"\" width=\"547\" height=\"422\" \/><\/p>\n<p>The next screen collects a lot of information and offers choices. The &#8220;?&#8221; icon is very helpful. The DBaaS service gives not just the database, but a host too, and we can choose the host compute level.<\/p>\n<p id=\"EiBEDDq\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1787 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822822ab7c4d.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p id=\"JHithMc\">As you can see here, you could have the host as small as 1 OCPU (<em>remember one vCPU is different from one OCPU &#8211; An OCPU provides CPU capacity equivalent of one physical core of an Intel Xeon processor with hyper threading enabled. Each OCPU corresponds to two hardware execution threads, known as vCPUs<\/em>) and 8GB RAM; or as big as 16 OCPU and 240GB RAM.<\/p>\n<p>Service Configuration section is where you specify the database host name (service name), compute size, time zone and the SSH public key file generated in the earlier &#8220;Create SSH Private and Public Keys&#8221; section.<\/p>\n<p id=\"TqHBdum\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1788 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822874e26bd2.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>In the Database Configuration section, specify the storage required for the database, administrator password, database name and the first pluggable database name.<\/p>\n<p id=\"mvSSEqQ\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1789 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_582287bd3bddc.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>In the Backup and Recovery Configuration section, there are options to perform local backup, cloud backup or no backup. I chose no backup for now, will enable backup at a later time.<\/p>\n<p id=\"DOSlCvX\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1790 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228818abd00.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>In this section, there are also configuration options to choose such as needing a standby database or configuring golden gate. I think these are pretty sleek, simple to the end-user.<\/p>\n<p id=\"xTbldkO\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1791 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_582288c29e0ee.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Now all required information are entered, and ready to create the DBaaS instance. The confirmation screen is shown.<\/p>\n<p id=\"KhARJQf\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1792 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_582289394a7fd.png?resize=532%2C419&#038;ssl=1\" alt=\"\" width=\"532\" height=\"419\" \/><\/p>\n<p>Fingers crossed, and I clicked\u00a0<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1793 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822895e490f2.png?resize=54%2C29&#038;ssl=1\" alt=\"\" width=\"54\" height=\"29\" \/><\/p>\n<p>Got the instance creation progress screen.<\/p>\n<p id=\"aGkhYhi\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1794 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_582289a978879.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>I thought this would be quick, waited 15 minutes, progress screen did not change. There are few other places to check status, such as the &#8220;Activity&#8221; section.<\/p>\n<p id=\"GHPXTkl\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1795 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_582289f62de13.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>After about 45 minutes, the instance creation was complete.<\/p>\n<p id=\"IplcroY\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1796 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228a1b7168f.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>The instance information screen showed all the details I need to connect to the database.<\/p>\n<p id=\"ejvVjVb\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1797 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228a4fc33a2.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>The instance (host) seems to be down (yellow bar). So clicked on the menu icon, and chose Start.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1798 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228bb7e5ecb.png?resize=166%2C115&#038;ssl=1\" alt=\"\" width=\"166\" height=\"115\" \/>\u00a0 \u00a0\u00a0<img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1800 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228bdce399b.png?resize=231%2C79&#038;ssl=1\" alt=\"\" width=\"231\" height=\"79\" \/><\/p>\n<p id=\"NNZzqWy\">And, there I have my host and database ready to use!<\/p>\n<p id=\"bXVqcvd\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"size-full wp-image-1801 aligncenter\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_58228c1551f97.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Next, I will share how to connect to this DBaaS instance using SQL Developer.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Got excited to see Oracle Database 12.2 available on Oracle Cloud DBaaS, and wanted to try it out immediately. This blog is my first experience, and I will continue sharing as I learn Oracle DBaaS myself! Oracle has provided an excellent step by step quick start document. Though the document is not updated with 12.2 &#8230; <a title=\"Exploring #Oracle #Cloud #DBaaS &#8211; The Start!\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1782\/\" aria-label=\"Read more about Exploring #Oracle #Cloud #DBaaS &#8211; The Start!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1782","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1782","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1782"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1782\/revisions"}],"predecessor-version":[{"id":2997,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1782\/revisions\/2997"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1782"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1782"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1782"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}