MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

SQL Developer JVM Fix

with 5 comments

It’s amazing the moving parts in Oracle Database 11g, and the ones that I don’t use after installation for a while often reach out to teach me something new. That’s what happened when I went to launch SQL Developer on my Windows 7 Professional 64-bit installation.

I got the message Unable to find a Java Virtual Machine, as shown in the image below. It really means unable to find a 32-bit Java 5 or Java 6 (1.6.0_4+) SDK home. Although the installation appeared fine, it pointed the SQL Developer configuration file to an incompatible 64-bit Java 7 SDK.

You fix this error by following these steps:

  1. Open the sqldeveloper.conf file and check the SetJavaHome parameter value. You find the sqldeveloper.conf file in the following directory:
%ORACLE_HOME\sqldeveloper\sqldeveloper\bin
  1. Install the 32-bit Java 6 (1.6.0_4+) SDK on the operating system if not installed already. You can check whether it’s installed by looking for it in the Program Files (x86) folder.
  2. Change the value of the SetJavaHome parameter to point to the new 32-bit Java 6 home directory (or folder). The following change to line 18 in the sqldeveloper.conf file should fix it on your installation (provided that’s your version of the JVM).
18
SetJavaHome C:\Program Files (x86)\Java\jdk1.6.0_34

Hope this helps those who run into the same issue.

Written by maclochlainn

August 15th, 2012 at 6:01 pm

5 Responses to 'SQL Developer JVM Fix'

Subscribe to comments with RSS or TrackBack to 'SQL Developer JVM Fix'.

  1. […] SQL Developer fix is found […]

  2. […] another post on a related element of this topic […]

  3. Hi,
    I am unable to open the .conf file. I installed the Java JDk 7 version, but it is not showing in my
    C: \ Program Files (x86) folder, it is just showing it in my C:\Program Files folder. I tried giving the C:\Program Files path in the dialogue box that prompted me to enter the path (However, this dialogue box came only the 1st time I tried to run SQL developer, the next time onwards I just see the error message shown above). Would it help if I install just JRE 6? I have Windows 7 Enterprise edition on my office laptop and have a standalone SQL developer installation. I have both JRE 6 and JRE 7 installed.

    How do I open the .conf file?
    Do I need to uninstall the Java JDK 7? If so, how?
    I am a beginner Oracle learner, please help.

    Thanks!
    Nancy

    NancyD

    5 Jan 13 at 2:42 pm

  4. Yes, you should install Java JDK 6. You don’t need to uninstall JDK 7 but patch it because it’s got a nasty bug.

    maclochlainn

    15 Jan 13 at 10:19 pm

  5. In windows 7, sometimes you need to copy and paste the msvcr71.dll to sqldeveloper\bin directory.

    Diva

    21 Aug 13 at 10:29 am

Leave a Reply