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.

Unable to install Jdev - Couldn't rename temporary file - Copy

Recently I encountered a very strange problem while installing Jdeveloper 12.1.3 on new laptop. While installing using windows installer (64-bit) , at the copy operation it throws below exception.


[2014-06-30T22:32:11.916-04:00] [sysman] [NOTIFICATION] [] [oracle.sysman.oii.oiio.oiiol.OiiolTextLogger] [host: Chandra] [nwaddr: 192.168.1.79] [tid: 46] [userId: Chandra] [ecid: 0000KRjkrdsFc5WFLzYROA1JgXn^000006,0] java.io.IOException: java.io.IOException: com.oracle.cie.common.util.crlf.CRLFException: Failed to transform D:\Oracle\Middleware\Oracle_Home\oui\bin\viewInventory.cmd to D:\Oracle\Middleware\Oracle_Home\oui\bin\viewInventory.cmd. Couldn't rename temporary file: D:\Oracle\Middleware\Oracle_Home\oui\bin\fixcrlf535545165763140000
[2014-06-30T22:32:11.917-04:00] [sysman] [NOTIFICATION] [] [oracle.sysman.oii.oiic.OiicAPIInstaller] [host: Chandra] [nwaddr: 192.168.1.79] [tid: 39] [userId: Chandra] [ecid: 0000KRjkotUFc5WFLzYROA1JgXn^000004,0] oracle.sysman.oii.oiif.oiifb.OiifbEndIterateException: java.io.IOException: java.io.IOException: com.oracle.cie.common.util.crlf.CRLFException: Failed to transform D:\Oracle\Middleware\Oracle_Home\oui\bin\viewInventory.cmd to D:\Oracle\Middleware\Oracle_Home\oui\bin\viewInventory.cmd. Couldn't rename temporary file: D:\Oracle\Middleware\Oracle_Home\oui\bin\fixcrlf535545165763140000


There are some posts on OTN which tells about providing the correct (Full permisions) to the jdev installer exe file.

But the actual problem was due to Anti Virus. On disabling the antivirus, the Installation is smooth. So if anyone encounters the above exception , try disabling the antivirus and perform the installation.

Thanks

NIAIOUG - 9th Tech Meet at Jaipur India

I will be a part of 9th NIAIOUG Tech meet at Jaipur Rajasthan India. This is for the first time NIAIOUG is organizing Oracle User Group Tech Meet in Rajasthan. I am very please to be part of this meet and look forward to a great audience at JECRC University Jaipur. Hope to see some awesome IT Professionals and Students in my session.

Aman, Nikhil and Navneet will be speaking on Database topics. This all will be very useful for DBA's as well as aspiring DBA's.

I will be speaking on ADF and Jdeveloper 12c. There will be a small demo at the end and then there will be open question answers session where anyone can ask questions as how to learn , move into Oracle ADF.

Hope to have a good time @ JECRC Jaipur.

Thanks !!