SQL Developer failed to start

Question

I've just installed SQL Developer 4.1.1 64-bit on a Windows Vista machine, in directory c:\sqldeveloper.

My Java installation is in c:\program files\java and I have two sub- directories:

c:\program files\java\jdk1.8.0_31
c:\program files\java\jdk1.8.0_25

I have modified the jdf.conf and sqldeveloper.conf files in the c/sqldeveloper/sqldeveloper/bin directory. jdf.conf was empty and I added the following line:

SetJavaHome

c:\program files\java\jdk1.8.0_31

sqldeveloper.conf:

#SetJavaHome ../../jdk    <===== This is what is was 
SetJavaHome c:/program files/java/jdk1.8.0_31 <======= I changed it to this

I even moved the missing file "msvcr100.dll" it was asking for to the c:/sqldeveloper/sqldeveloper/bin directory.

I got the following error messages:

1. This application has failed to start because msvcr100.dll was not found. Re-installing this application may fix this problem

2. Unable to launch the java virtual machine located at path

   c:\sqldeveloper\jdk\jre\bin\server\jvm.dll

The file msvcr100.dll is in the Java directory c:/program files/java/jdk1.8.0_31/bin.

The file jvm.dll is in the Java directory c:/program files/java/jdk1.8.0_31/bin/jre/bin/server.

I modified product.conf:

#SetJavaHome /path/jdk   <===== This is what it was
SetJavaHome C:/Program Files/Java/jdk1.8.0_31   <====== This is what I changed it to

I have a copy of msvcr100.dll in sqldeveloper/sqldeveloper/bin folder and in the c:/program files/java/jdk1.8.0_31/bin folder.

To run SQL Developer I click on sqldeveloper.exe in the c:/sqldeveloper/sqldeveloper/bin directory.

Is I am running it on the correct way?

Answer 1

I ran in to the same problem myself, trying to run SQL Developer 4.1.1 64-bit with JDK on a Windows Server 2008. I've installed SQL Developer many times over the years from 1.x to 4.1.1 and never encountered this until now.

I solved it by copying the MSVCR100.dll file from sqldeveloper\jdk\jre\bin to the sqldeveloper\sqldeveloper\bin folder.

Update 3/18/2017:

In downloading the latest version from Oracle's website, I found this in the installation notes which confirms and explains the issue:

Note: the Windows EXE requires a MSVCR100.dll to run. Most computers will already have this file and in the Windows PATH. However, if the first copy of the file found by the EXE is a 32-bit copy of the DLL, then SQL Developer will fail to start. You can fix this by copying a 64-bit version of the DLL into the BIN directory or updating your OS PATH such that a 64 bit copy of the DLL is found first.