{"id":1808,"date":"2016-12-14T00:00:40","date_gmt":"2016-12-14T06:00:40","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1808"},"modified":"2026-02-07T15:27:14","modified_gmt":"2026-02-07T21:27:14","slug":"12-days-of-cloud-connecting-to-oracle-dbaas-using-sqldev","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1808\/","title":{"rendered":"12 Days of #Cloud: Connecting to #Oracle #DBaaS using #SQLDev"},"content":{"rendered":"<h2><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-1821 alignright\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?resize=149%2C86&#038;ssl=1\" alt=\"image22\" width=\"149\" height=\"86\" \/><\/a>12 Days of #Cloud: Day 1<\/h2>\n<p>There are two ways for SQL Developer to connect to a DBaaS Cloud Instance.<\/p>\n<p>Review how to\u00a0<a href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1782\">create a DBaaS Cloud Instance<\/a>.<\/p>\n<p><span style=\"text-decoration: underline;\"><strong>1. Using SQL*Net<\/strong><\/span><\/p>\n<p>By default, the Oracle DBaaS Cloud Service blocks access to 1521 port used by SQL*Net. You have to open the port before you can connect using SQL Developer.<\/p>\n<p>Log in to the Oracle Database Cloud Service and click on the service name to see the details. Note down the Public IP address and the Connect String.<\/p>\n<p id=\"xFADjoR\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1809 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850df263fa92.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Click on the Database Cloud Service menu and choose &#8220;Access Rules&#8221;.<\/p>\n<p id=\"htMqFWG\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1810 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850dfae63346.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Enable the &#8220;ora_p2_dblistener&#8221; access rule, by clicking the menu under Actions.<\/p>\n<p>Now, you can use SQL Developer from your desktop to connect to the Cloud Database as you would connect to any on-premise database. Use the Public IP address as the hostname and the service name in the connect string.<\/p>\n<p id=\"yrNaYoM\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1812 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e08d8a5eb.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p><span style=\"text-decoration: underline;\"><strong>2. Using SSH<\/strong><\/span><\/p>\n<p>This method is a bit more secure. Let&#8217;s turn off the 1521 port to make sure our connection using SSH works indeed. Confirm SSH is enabled.<\/p>\n<p id=\"YhblEsv\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1813 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e10805704.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>In SQL Developer menu, click on View &#8211;&gt; SSH. Then right click and choose &#8220;Create New SSH Host&#8221;.<\/p>\n<p id=\"CCFMlSX\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1814 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e14c48076.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Provide the Cloud Database Service Public IP address and the SSH key file. Enable port forwarding on port 1521.<\/p>\n<p>Oops, I chose a wrong key file. Instead of the private key, selected the public key file. Let me fix by editing the SSH host entry.<\/p>\n<p id=\"UMkRVOM\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1815 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e1d5e47d1.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>Now choose &#8220;New Connection&#8221; in SQL Developer, and configure a connection using connection type SSH. You still have to enter the service name of the cloud database.<\/p>\n<p id=\"qCzvaZb\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1816 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e21152d51.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>When you click Test button, \u00a0you will be asked the SSH key passphrase.<\/p>\n<p id=\"lBmaHDY\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1817 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e25f599b3.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>And, that&#8217;s it. You are ready to go.<\/p>\n<p id=\"mqkvxwd\"><img data-recalc-dims=\"1\" decoding=\"async\" class=\"alignnone size-full wp-image-1818 \" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/img_5850e278c6f56.png?w=1200&#038;ssl=1\" alt=\"\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>12 Days of #Cloud: Day 1 There are two ways for SQL Developer to connect to a DBaaS Cloud Instance. Review how to\u00a0create a DBaaS Cloud Instance. 1. Using SQL*Net By default, the Oracle DBaaS Cloud Service blocks access to 1521 port used by SQL*Net. You have to open the port before you can connect &#8230; <a title=\"12 Days of #Cloud: Connecting to #Oracle #DBaaS using #SQLDev\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1808\/\" aria-label=\"Read more about 12 Days of #Cloud: Connecting to #Oracle #DBaaS using #SQLDev\">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_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[4],"tags":[55],"class_list":["post-1808","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack-related-posts":[{"id":1782,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1782\/","url_meta":{"origin":1808,"position":0},"title":"Exploring #Oracle #Cloud #DBaaS &#8211; The Start!","author":"Biju","date":"November 8, 2016","format":false,"excerpt":"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\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822800f4d273.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822800f4d273.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/11\/img_5822800f4d273.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1879,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1879\/","url_meta":{"origin":1808,"position":1},"title":"12 Days of #Cloud: PDB Management Using #DBaaS Monitor Console","author":"Biju","date":"December 17, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 4 DBaaS Monitor Console is part of the Oracle Database Cloud Service.\u00a0DBaaS Monitor Console provides information on the\u00a0database and operating system status and resource usage. If you are managing the database with Oracle Enterprise Manager Cloud Control or if you are familiar with Linux commands,\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/12\/image22.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1742,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1742\/","url_meta":{"origin":1808,"position":2},"title":"Oracle Tidbits &#8211; August 2016","author":"Biju","date":"September 4, 2016","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published at\u00a0https:\/\/www.facebook.com\/oraclenotes\u00a0on weekdays\u00a0in August\u00a02016. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you of its existence and use\u2026\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2022,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/2022\/","url_meta":{"origin":1808,"position":3},"title":"12th Day of #Cloud: Thoughts","author":"Biju","date":"December 31, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 12 After playing with Oracle Database Cloud Service (DBaaS) for past several days, I have mixed feeling. I like quite a lot of features and the amount of automation went into the product. For example, creating an RAC instance and creating a Data Guard instance\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1823,"url":"https:\/\/bijoos.com\/oraclenotes\/2016\/1823\/","url_meta":{"origin":1808,"position":4},"title":"12 Days of #Cloud: Creating a RAC #DBaaS","author":"Biju","date":"December 15, 2016","format":false,"excerpt":"12 Days of #Cloud: Day 2 Today, let's create a 2 node RAC instance on Oracle Cloud. The database creation steps are similar. First, choose the release of the\u00a0database. \u00a0 The Service Packaging definition says \"Standard and Enterprise packages include their respective on-premises capabilities and add Transparent Data Encryption. High\u2026","rel":"","context":"In &quot;Cloud &amp; Autonomous Database&quot;","block_context":{"text":"Cloud &amp; Autonomous Database","link":"https:\/\/bijoos.com\/oraclenotes\/category\/cloud-autonomous\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2115,"url":"https:\/\/bijoos.com\/oraclenotes\/2017\/2115\/","url_meta":{"origin":1808,"position":5},"title":"Oracle Tidbits &#8211; October 2017 #oratidbit","author":"Biju","date":"November 2, 2017","format":false,"excerpt":"\u201cOracle *daily* TidBits\u201d (#oratidbit) published on Facebook, Twitter, and Google+\u00a0during weekdays\u00a0in October 2017. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well\u2026 Hope you find these helpful to learn something new or to remind you\u2026","rel":"","context":"In &quot;TidBits &amp; Quick Tips&quot;","block_context":{"text":"TidBits &amp; Quick Tips","link":"https:\/\/bijoos.com\/oraclenotes\/category\/tidbits\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2017\/02\/oratidbit.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1808","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=1808"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1808\/revisions"}],"predecessor-version":[{"id":2996,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1808\/revisions\/2996"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}