Thursday, December 27, 2012

SQL Developer from 11.2.0.1 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.

AND IT WORKED!!!

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

9 comments:

  1. Thanks, you saved me some time today

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

    ReplyDelete
  3. Omar Kalombo

    It worked thank you very much

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

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

    ReplyDelete
  6. Thanks a lot for sharing this info!

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

    ReplyDelete