Monday, June 13, 2016

Create Oracle Cloud Database Connection in Jdeveloper 12.2.1

While doing development on J2EE and ADF very often it is needed to create Oracle Database Connection from Jdeveloper. Jdeveloper provides a wonderful easy window to create and manage multiple Database Connections.

Since the environments have started to move to Cloud much often it is required to create Database Connection for the Oracle Database which is hosted on Oracle Database Cloud Service (DBCS).

There was no way to create SSH Tunnel in Jdeveloper and one has to tunnel the traffic using Putty or SSH command and then use the localhost in jdeveloper database connection window to create successful connection to Database on Cloud.

Jdeveloper 12.2.1 solved this problem by providing a very nice SSH Tunnel window in Database Connections Set up. This SSH Tunnel Configuration can be used to do configure the tunnel and use SSH Public key and user to create the connection.

Below is the process for creating a successful Database Cloud Instance connection from Jdeveloper 12.2.1

On clicking + sign for adding new connection, below window pops up.

Give a name to the connection and provide username & password.

Leave hostname as localhost and provide name of PDB in service name which you are connecting if using Oracle DB 12c.

It goes in this format : PDBNAME.IdentityDomain.oraclecloud.internal

Now click on SSH. This is the new button in Jdev 12.2.1 which will open Tunnel Configuration. We are actually tunneling traffic to port 1521 thru SSH using this window.

On the SSH Tunnel window, click on Use SSH.

Provide the SSH Host name which is the IP Address of the VM on DBCS.

Uncheck - Current user and key in oracle as SSH User.

Check Public Key for Authentication.

Browse & select the private key file by clicking Browse button.

Check on Save Passphrase if you have set Passphrase and provide passphrase for your private key if there is any. This will prevent jdev asking for passphrase again and again every time you connect to Database Instance.

Click OK.

Click on Test Connection. It should be successful.

Here you go. SSH Tunnel configuration window in Jdev 12.2.1 makes it very simple to create connection to Database Instance on Oracle Public Cloud without using any other tool or command to tunnel the connections.



  1. Thanks .... almost got screwed from my manager if it was'nt for this article........

    1. Thanks Abhishek. Glad you liked this post!!

  2. Thanks for providing this informative information you may also refer.

  3. Hi,
    Thanks for the valuable information posted by you on oracle cloud.keep posting such articles.
    Thank you.
    oracle fusion training


  4. Nice blog. Really helpful information about Oracle …. Please keep update some more…………

  5. Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
    iphone app training course in bangalore

  6. Create Oracle Cloud Database Connection in Jdeveloper 12.2.1 I thank you so much for providing such a good content mainly I was looking for this type of source to know how can we create Oracle cloud Database Connection in Jdeveloper Leaving at the versions If once it is done to get installed it will be effective to other versions also Well I being a PMP Certified and I completed my PMP in Mumbai with all the major solutions of different Projects regarding Oracle Cloud. Thank you so much please Keep Updating

  7. It has been simply incredibly generous with you to provide openly what exactly many individuals would’ve marketed for an eBook to end up making some cash for their end, primarily given that you could have tried it in the event you wanted "Oracle Training in Bangalore".
    "Devops Training in Bangalore"

  8. Are you looking for Best Cloud Computing training in Delhi. DIAC offering best online Salesforce training , CRM training, Salesforce Lightning - Admin developer training. Free Demo Class. Call now 9310096831.

  9. Test failed: IO Error: Got minus one from a read call

  10. Hi,
    Thanks for the valuable information posted by you on oracle cloud.keep posting such articles.

    WEBLOGIC Training

  11. This concept is a good way to enhance the knowledge.thanks for sharing. please keep it up salesforce Online Training Bangalore

  12. The most effective method to Solve Oracle Connection on Windows through Remote DBA Service
    Have you ever stood up to Oracle Connection issue on Windows? Or on the other hand any sort of issue with respect to Oracle? In the event that yes, at that point picking a standout amongst other backings who appropriately take minds your issue by disposing of the issues. You will get this sort of help through Database Administration for Oracle and Online Oracle DB Support. At whatever point you need Oracle support you will quick through Oracle Database Solution. Our help is 100% honest to goodness and adaptable with the goal that you don't need to pick some other help.
    For More Info:
    Contact Number: 1-800-450-8670
    Email Address-
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

  13. I Just Love to read Your Articles Because they are very easy to understand.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts Through Out US At Very Affordable Prices And Also We Offer Same Day Shipping In US.We Offer Only Genuine Products.Thanks For Posting.HAve a Nice Day!

  14. This Blog Drives Me For Increasing my knowledge and to understand the basic concepts,really helpful and thankful we provide Urgent Care Services.Really Thanks For Posting Such an informative Article.I want to share this blog with my friends and family.

  15. It's really interesting blog Thanks for sharing
    Oracle SOA Online Training

  16. This Blog is very helpful and useful, came to know that I should be strong in my basics and this blog helps me to improve it, US Medical Residency in Chicago Services Provided by Us. Thanks For Posting.

  17. This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. United States Medical Licensing Examination

  18. Thanks For Sharing Such an Important and Useful Content On Mulesoft Certification Training