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

65 comments:

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

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

    ReplyDelete
  3. 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
  4. 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
  5. Test failed: IO Error: Got minus one from a read call

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

    WEBLOGIC Training

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

  9. 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
  10. 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
  11. Thanks For Posting Such an Informative Content.....

    Vizag Real Estate

    ReplyDelete
  12. 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
  13. 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
  14. Latest News in Hindi

    Latest News in Hindi- Hindustan channel is the best online web portal in india where you read the all latest indian news in hindi. if you are looking the Latest News in Hindi, live news channel, hindi news channel, live news channels in hindi, live hindi channels then hindustan channel is best for you.
    Latest News in Hindi
    Company address:
    C- 67, Sector- 63, Noida
    Phone: 01204330760, 8802820025


    URL: https://hindustanchannel.com

    ReplyDelete
  15. Thanks for providing such a great information in the blog and also very helpful to all.learn best Oracle Fusion HCM Online Training.

    Oracle Fusion HCM Online Training

    ReplyDelete
  16. Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.Trending Software Technologies in 2018 | Hadoop Training in Chennai | big data Hadoop training and certification in Chennai | Roles and reponsibilities of hadoop developer

    ReplyDelete
  17. I like this article very much, if Anyone Reads Your Blog, Each And Every one will appreciate you.
    Oracle Fusion SCM Online Training

    ReplyDelete
  18. First Of all I would like to say thanks for sharing this information, If Anyone sees Your Blog, and Each And Every one will appreciate you.
    Oracle Fusion HCM Online Training

    ReplyDelete
  19. #Oracle #Applications comprise the applications ##software or business software of the Oracle Corporation. The term refers to the non-database and non-middleware parts.

    Oracle sells many functional modules which use the Oracle #RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle #SCM, Oracle Projects, Oracle CRM and Oracle Procurement.

    Want to Learn Top Oracle Apps technical training, then you may visit the following link, and Training will be provided by top industry experts.

    ReplyDelete
  20. Its a wonderful post and very helpful, thanks for all this information. You are including better information.
    Oracle Training in Delhi

    Oracle Training institute in Delhi

    ReplyDelete
  21. Its a wonderful post and very helpful, thanks for all this information. You are including better information.
    Oracle Training in Delhi

    Oracle Training institute in Delhi

    ReplyDelete
  22. Amazing web journal I visit this blog it's extremely marvelous. Interestingly, in this blog content composed plainly and reasonable. The substance of data is educational.Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

    ReplyDelete
  23. Thanks for Sharing this great article..Its really nice and useful for us… keep sharing..AWS Training In Hyderabad

    ReplyDelete
  24. A bewildering web journal I visit this blog, it's unfathomably heavenly. Oddly, in this present blog's substance made purpose of actuality and reasonable. The substance of data is informative
    A befuddling web diary I visit this blog, it's incredibly grand. Strangely, in this present blog's substance made motivation behind fact and sensible. The substance of information is instructive
    Oracle Fusion Financials Online Training
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training

    ReplyDelete
  25. Thank you for sharing valuable information.
    You can also check this links. Hope it can help you and your friend, who is looking for job.
    If you have experienced 2 to 4 years, then you can come for interview round. For more details you can direct call on this number @ +91 8750003480.
    It is totally free service. Free Free Free !!
    Jobs in Travel Consultant Only For Female | Travel Planner
    Thank you.

    ReplyDelete
  26. Are you looking for Distance Learning Courses in India most of the students choose and apply, Talentedgenex there are many popular courses which attract the students for having distance education. For more info visit this site:- Distance learning courses in India ,

    ReplyDelete
  27. Talentedgenext Way of Online Learning, Distance Education, is an increasing number of becoming popular all over the world due as it has many benefits. For further details visit in this site:- Distance Education Website,

    ReplyDelete
  28. Online BBA degree in India is one of the most popular couses for students who are keen to learn business statistics, communicating skills, marketing management, entrepreneurship and small business management, international business, etc. To know more, visit:
    Online BBA Degree in India,

    ReplyDelete
  29. Thank you for sharing valuable information.
    You can also check this links. Hope it can help you and your friend, who is looking for job change.
    If you have up to 10 years experience, then you can come for interview round. For more details you can direct call on this number @ +91 9250406614.
    It is totally free service. Free Free Free !!
    Jd for Group Manager (Oil and Gas research) - Gurgaon
    Thank you.

    ReplyDelete
  30. your information is really more knowledgeable to the new ones.Really I feel happy to see this useful blog, Thanks for sharing such a nice blog.hadoop training in btm layout

    ReplyDelete
  31. Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.
    Digital Marketing Training In Hyderabad
    sem training in hyderabad
    seo training in hyderabad
    SMM Training In Hyderabad

    ReplyDelete
  32. It is interesting and vary use full blog ,thanks for sharing this informative article.
    oracle fusion hcm online training

    ReplyDelete
  33. This comment has been removed by the author.

    ReplyDelete
  34. thanks for sharing.great blog poster blog.keep posting us.We are the Best Digital Marketing Agency in Chennai, Coimbatore, Madurai and change makers of digital! For Enquiry Contact us @+91 9791811111

    digital marketing consultants in chennai | Leading digital marketing agencies in chennai | digital marketing agencies in chennai | Website designers in chennai | social media marketing company in chennai

    ReplyDelete
  35. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle ADF . Actually I was looking for the same information on internet for Oracle ADF and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle ADF . By attending Oracle ADF.

    ReplyDelete
  36. This is my first time visit to your blog and I am very interested in the articles that you serve. Provide enough knowledge for me. Thank you for sharing useful and don't forget, keep sharing useful info:

    Saleforce Training in Gurgaon

    ReplyDelete
  37. This blog very easily understandable. Thanks for sharing such an informative post with us. This is a nice post in an interesting line of content.
    Best Oracle ADF Course in Bangalore

    ReplyDelete
  38. Thanks for sharing amazing information.Gain the knowledge and hands-on experience

    Oracle reviews in bangalore

    ReplyDelete
  39. I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here .Same as your blog i found another one Oracle Project Portfolio Management Cloud . Actually I was looking for the same information on internet for Oracle PPM and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.

    ReplyDelete
  40. My spouse and I love your blog and find almost all of your posts to be just what I’m looking for. Appreciating the persistence you put into your blog and the detailed information you provide. I found another one blog like you Oracle ADF.Actually I was looking for the same information on internet for Oracle Application Development Framework and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.


    ReplyDelete
  41. Grab Data Science Certification in Chennai ,for skyrocketing your career with Infycle Technologies, the best Software Training & Placement institutes in and around Chennai. In addition to the Certification, Infycle also gives the best placement training for personality tests, interview preparation, and mock interviews for leveling up the candidate's grades to a professional level.

    ReplyDelete
  42. Great content, I just go through your blogs daily. If you want to reach your customer easily just go for bulk sms india, we provides different kind of Bulk SMS services Without DLT | Free SMS API | Free Registration, one of the most effective, reliable and cost-effective ways to establish your businesses. It allows you to get a higher income and get a customer easily. Rat SMS is the most popular leading company who provides the best sms api Services.
    You can check with also best sms service provider in india

    ReplyDelete