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.

Thanks

46 comments:

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

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

      Delete
  2. Thanks for providing this informative information you may also refer.
    http://www.s4techno.com/blog/2016/08/01/cloud-computing-interview-questions/

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

    ReplyDelete

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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"

    ReplyDelete
  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.

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

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

    WEBLOGIC Training

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

    ReplyDelete
  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: https://cognegicsystems.com/
    Contact Number: 1-800-450-8670
    Email Address- info@cognegicsystems.com
    Company’s Address- 507 Copper Square Drive Bethel Connecticut (USA) 06801

    ReplyDelete
  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!

    ReplyDelete
  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.

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

    ReplyDelete
  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.

    ReplyDelete
  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

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

    ReplyDelete

  19. Best Solidworks training institute in noida

    SolidWorks is a solid modeling computer-aided design (CAD) and computer-aided engineering (CAE) computer program that runs on Microsoft Windows. SolidWorks is published by Dassault Systems. Solid Works: well, it is purely a product to design machines. But, of course, there are other applications, like aerospace, automobile, consumer products, etc. Much user friendly than the former one, in terms of modeling, editing designs, creating mechanisms, etc.
    Solid Works is a Middle level, Main stream software with focus on Product development & this software is aimed at Small scale & Middle level Companies whose interest is to have a reasonably priced CAD system which can support their product development needs and at the same time helps them get their product market faster.

    Company Address:

    WEBTRACKKER TECHNOLOGY (P) LTD.
    C-67,Sector-63,Noida,India.

    E-mail: info@webtracker.com

    Phone No: 0120-4330760 ,+91-880-282-0025


    http://webtrackker.com/solidworks-training-Course-institute-in-noida-delhi.php

    Best Solidworks training institute in noida

    ReplyDelete
  20. Artificial intelligence Training in noida
    Artificial intelligence Training in noida-Artificial Intelligence Training in Noida, Artificial Intelligence Training classes in Noida, Artificial Intelligence Training classes in Noida, Artificial Intelligence Training

    by Real time ARTIFICIAL INTELLIGENCE Experts, Big-Data and ARTIFICIAL INTELLIGENCE Certification Training in Noida



    WEBTRACKKER TECHNOLOGY (P) LTD.
    C - 67, sector- 63, Noida, India.
    F -1 Sector 3 (Near Sector 16 metro station) Noida, India.

    +91 - 8802820025
    0120-433-0760
    0120-4204716
    EMAIL: info@webtrackker.com
    Website: www.webtrackker.com



    Our Other Courses:


    artificial intelligence Training in noida

    SAS Training Institute in Delhi

    SAS Training in Delhi

    SAS Training center in Delhi

    Sap Training Institute in delhi

    Sap Training in delhi

    Best Sap Training center in delhi

    Best Software Testing Training Institute in delhi

    Software Testing Training in delhi

    Software Testing Training center in delhi

    Best Salesforce Training Institute in delhi

    Salesforce Training in delhi

    Salesforce Training center in delhi

    Best Python Training Institute in delhi



    Python Training in delhi


    Best Android Training Institute In delhi


    Best Python Training center in delhi


    Android Training In delhi


    best Android Training center In delhi

    ReplyDelete
  21. 6-week summer course in Noida - 6 weeks The summer course plays a crucial role in shaping the career of young aspiring / informatics students. This training has been specifically introduced so that students can become familiar with current industrial culture and industrial needs. Webtrackker technology offers a 6-month training program for students / graduates that includes small and large projects.
    6-week summer course in Noida

    ReplyDelete
  22. Data science Training Institute in Noida

    Webtrackker Data science Training Institute in Noida Accelerate your career in data science by starting from basics in Statistics, Data Management and Analytics to advanced topics like Neural Networks, Machine Learning and Big Data.



    http://webtrackker.com/Best-Data-Science-Training-Institute-in-Noida.php



    Data science Training Institute in Noida

    ReplyDelete
  23. 3D Animation and Multimedia Training in Noida
    Best institute for 3d Animation and Multimedia Course training Classes in Noida- webtrackker Is providing the 3d Animation and
    Multimedia training in noida with 100% placement supports. for more call - 8802820025.
    3D Animation and Multimedia Training in Noida
    Company Address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Phone: 01204330760, 8802820025
    Email: info@webtrackker.com
    Website: http://webtrackker.com/Best-institute-3dAnimation-Multimedia-Course-training-Classes-in-Noida.php

    ReplyDelete
  24. Graphics designing training institute in Noida
    Best Graphics training institute in Noida, Graphic Designing Course, classes in Noida- webtrackker is providing the graphics training in Noida with 100% placement supports. If you are looking for the Best Graphics designing training institute in Noida For more call - 8802820025.

    Graphics designing training institute in Noida, Graphics designing training in Noida, Graphics designing course in Noida, Graphics designing training center in Noida

    Company address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Phone: 01204330760, 8802820025
    Email: info@webtrackker.com
    Website: http://webtrackker.com/Best-institute-for-Graphic-Designing-training-course-in-noida.php

    ReplyDelete
  25. Thanks For Posting Such an Informative Content.....

    Vizag Real Estate

    ReplyDelete
  26. Each department of CAD have specific programmes which, while completed could provide you with a recognisable qualification that could assist you get a job in anything design enterprise which you would really like.

    AutoCAD training in Noida

    AutoCAD training institute in Noida


    Best AutoCAD training institute in Noida

    Company address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Phone: 01204330760, 8802820025
    Email: info@webtrackker.com

    ReplyDelete
  27. Video editing course in Noida
    Video editing training institute in Noida- Webtrackker Technology is and IT Training institute providing the Video editing course in Noida, FCP, Final Cut Pro Training in Noida. For more call us- 8802820025.
    Video editing course in Noida
    Company Address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Phone: 01204330760, 8802820025
    Email: info@webtrackker.com
    Website: http://webtrackker.com/Best-training-institute-Video-editing-FCP-course-in-Noida.php

    ReplyDelete
  28. Cloud Computing Training In Noida
    Webtrackker is IT based company in many countries. Webtrackker will provide you a real time projects based training on Cloud Computing. If you are looking for the Cloud computing training in Noida then you can join the webtrackker technology.
    Cloud Computing Training In Noida , Cloud Computing Training center In Noida , Cloud Computing Training institute In Noida ,

    Company Address:
    Webtrackker Technology
    C- 67, Sector- 63, Noida
    Email: info@webtrackker.com
    Website: www.webtrackker.com
    http://webtrackker.com/Cloud-Computing-Training-Institutes-In-Noida.php

    ReplyDelete