Database, DBA, dbcapoeira, EBS, Error, Hints and Tip, Hints and Tips, Java, JDK, JRE, SQLDev

Installing SQL Dev 4.0 (JRE 1.6 and JDK 1.7)

I’m in an environment where our 11i version of EBS (I know we need to upgrade) still requires JRE 1.6 to open Oracle Forms.  Being an SQL Developer fan (listen to my podcast here), I decided to download and install SQL Dev 4.0.  Anyone that’s been following this knows that the latest release requires JDK 1.7. Okay, I visit the Java site to grab 1.7 and install it.  It’s the JDK right? Everything should be fine.

Houston, we have a problem!  I launch EBS, try to open a form and nothing … nada … zero. Turns out, and it’s me just going with the default install options, that the JDK also upgrades JRE 1.6 to 1.7 rendering my instance of EBS basically useless.  Fortunately, it was an easy fix.

I did start from scratch and uninstall all Java related JREs and JDKs, just to have a clean start.  From there, I did the following:

  1. Installed JRE 1.6_65.  You can find that here.
  2. Successfully tested opening a form in EBS 11i
  3. Installed only the JDK 1.7 by unselecting the option to install the JRE
  4. Launched SQL Developer 4.0.
It “found” the correct path automagically, and all is well.
Hopefully, this might help someone out.