Tuesday, March 18, 2014

SQL Developer : Unable to create an instance of the Java Virtual Machine

Have you ever got this error message with SQL Developer ?

"... Unable to create an instance of the Java Virtual Machine ..."

It usually appears the first time you try to launch "SQL Developer" ( I have also found others get similar message with JDeveloper). The error is related to the memory allocated for the  JVM associated with the program we are trying to launch.

There are two SQLDeveloper parameter settings for this purpose :

Add32VMOption  -Xms  and
Add32VMOption  -Xmx

Which can be set in the file product.conf located at (in windows):

C:\Documents and Settings\Administrator\Application Data\sqldeveloper\1.0.0.0.0

So, in my case all I had to do is apply the following changes in this file:

# SetJavaHome C:\Program Files\Java\jdk1.6.0_45 (not required but wanted to use latest JDK)
SetJavaHome C:\Program Files\Java\jdk1.7.0_51


# AddVMOption -Xms128m
AddVMOption -Xms256m

# AddVMOption -Xms800m
AddVMOption -Xmx512m

You finally get :




Posted by at

18 comments:

  1. AnonymousMarch 21, 2014 at 8:27 AM

    Thanks Jorge, you saved my day.
    In our company we have "only" 32bit Win7 with 4 gb ram.

    ReplyDelete
  2. AnonymousMay 20, 2014 at 9:12 AM

    Thanks. This worked for me.
    - Volowski

    ReplyDelete
  3. AnonymousSeptember 17, 2014 at 7:29 AM

    Worked for me as well. Thanks a lot.

    ReplyDelete
  4. AnonymousSeptember 29, 2014 at 5:20 AM

    Fix still good - September 2014 - many thanks

    ReplyDelete
  5. AnonymousOctober 10, 2014 at 1:33 AM

    Thanks Jorge, It's working :)
    -Sameer

    ReplyDelete
  6. AnonymousNovember 4, 2014 at 8:24 AM

    Hi, for Windows 7, there is no longer any Documents & Settings, and no product.conf file stored in appdata.
    You will need to change the sqldeveloper.conf file:
    “{ORACLE_HOME}\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf"

    Add the 2 options as mentioned :
    AddVMOption -Xmx512m
    AddVMOption -Xms256m

    That worked for me - Liz

    ReplyDelete
  7. AnonymousNovember 12, 2014 at 8:05 AM

    Thanks!, can you explain the why?. Thanks again

    ReplyDelete
    Replies
    1. Jorge AnicamaNovember 18, 2014 at 6:55 PM

      Hi there. Not sure about the reasons for this to be an issue. But fortunately we found a workaround. Thanks for your feedback.
      regards

      Delete
  8. AnonymousNovember 20, 2014 at 3:18 PM

    thank you!

    ReplyDelete
  9. AnonymousDecember 1, 2014 at 2:58 AM

    Thanks very much... its very short & clean explanation....

    ReplyDelete
  10. AnonymousJanuary 18, 2015 at 5:37 PM

    thank you :) your explantation save me time

    ReplyDelete
  11. AnonymousFebruary 12, 2015 at 5:39 PM

    thkns so much but only 2 thing that maybe works only in my case
    1. the directory is C:\sqldeveloper\ide\bin ('c' is where i put sqldeveloper) and the file is ide.conf
    2. i only have "SetJavaHome" but not the rest, what i do is before to "SetJavaHome" put inmediatly "C:\Program Files\Java\jdk1.7.0_51" without quotes
    the memery is the same in your case and voila... it works!!!

    ReplyDelete
  12. AnonymousMarch 15, 2015 at 7:12 PM

    Thanks. This piece of information helped me today. Appreciate your time in writing this article - VJ

    ReplyDelete
  13. ShivaSeptember 22, 2015 at 6:27 AM

    at which line can I add it at the end

    ReplyDelete
  14. UnknownJune 22, 2016 at 2:58 AM

    In my case the problem was from TeamViewer. Closed that app and SqlDeveloper started normaly.

    ReplyDelete
  15. UnknownJune 22, 2016 at 3:03 AM

    In my case problem was TeamViewer. After closing that app, SqlDeveloper started normaly. No need to change any config files.

    ReplyDelete
  16. UnknownAugust 5, 2016 at 4:38 AM

    Hi,

    I am not able to find # AddVMOption -Xms128m
    AddVMOption -Xms256m this files.

    Can anybody help?

    ReplyDelete

Subscribe to: Post Comments (Atom)