{"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":"

\"image22\"<\/a>12 Days of #Cloud: Day 1<\/h2>\n

There are two ways for SQL Developer to connect to a DBaaS Cloud Instance.<\/p>\n

Review how to\u00a0create a DBaaS Cloud Instance<\/a>.<\/p>\n

1. Using SQL*Net<\/strong><\/span><\/p>\n

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

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>\n

Click on the Database Cloud Service menu and choose “Access Rules”.<\/p>\n

\"\"<\/p>\n

Enable the “ora_p2_dblistener” access rule, by clicking the menu under Actions.<\/p>\n

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>\n

2. Using SSH<\/strong><\/span><\/p>\n

This method is a bit more secure. Let’s turn off the 1521 port to make sure our connection using SSH works indeed. Confirm SSH is enabled.<\/p>\n

\"\"<\/p>\n

In SQL Developer menu, click on View –> SSH. Then right click and choose “Create New SSH Host”.<\/p>\n

\"\"<\/p>\n

Provide the Cloud Database Service Public IP address and the SSH key file. Enable port forwarding on port 1521.<\/p>\n

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>\n

Now choose “New Connection” 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>\n

When you click Test button, \u00a0you will be asked the SSH key passphrase.<\/p>\n

\"\"<\/p>\n

And, that’s it. You are ready to go.<\/p>\n

\"\"<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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 … 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":[55],"class_list":["post-1808","post","type-post","status-publish","format-standard","hentry","category-cloud-autonomous","tag-oracle-cloud"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_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}]}}