Thursday, December 27, 2012

SQL Developer from client software

Installed 11gR2 64-Bit Client on Windows 7 (64-Bit).

Tried to launch sqldeveloper from
Start-> All Programs -> Oracle - OraClient11g_home1 -> Application Development -> SQL Developer

Got below error:

Properties for that shortcut show that its looking for sqldeveloper.bat, which is not actually present.
But below executables are available at the same location:
sqldeveloper.exe and sqldeveloperW.exe

Modified the target to sqldeveloperW.exe and tried to launch the sqldeveloper. It asked the full path for JAVA.exe

Browsed to $ORACLE_CLIENT_HOME\jdk\bin

It failed with below message:

Did google on above error and found that 64-Bit JDK is not supported for sqldeveloper.

So dowloaded and installed 32 bit JDK (jdk-6u37-windows-i586.exe)

Remove below line from sqldeveloper.conf so that next time you launch sqldeveloper it prompts you to provide JAVA.exe location and then you can point it to newly installed 32 bit JDK.

    SetJavaHome C:\app\admin\product\11.2.0\client_1\jdk

Launch sqldeveloper. Provide new path for JAVA.exe.


After it launched, I checked version using Help -> About. It showed it is version 1.5.5.

But the latest version available for sql developer on oracle website is 3.2.2.

I will write another post to describe how to upgrade to 3.2.2


  1. Thanks, you saved me some time today

  2. This error is because Oralce provide SQL Developer 1.5 (older version, current is 3.2) with a 64 bit version of latest Oracle that requires a 32 bit JDK to work.

  3. Omar Kalombo

    It worked thank you very much

  4. thank you so much! this problem was driving me crazy

  5. OMG! You saved my time. Thank you very much Bro

  6. Thanks a lot for sharing this info!

  7. Thanks Buddy..You saved lot of time....