Forum Stats

  • 3,815,265 Users
  • 2,258,988 Discussions
  • 7,893,019 Comments

Discussions

unable to create an instance of the java virtual machine

Tony007
Tony007 Member Posts: 4,224 Bronze Trophy
edited Jun 24, 2014 11:34AM in SQL Developer

hi when i try to lauch my sql developer am geting this error

unable to create an instance of the java virtual machine located at path C:\Program Files\Java\jdk1.6.0_38\jre\bin\client\jvm.dll but i do have the file in location

am trying to do this

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

Unable to create an instance of the Java Virtual Machine

but am not able to locate file product.conf in my machine

Best Answer

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    edited Jun 24, 2014 5:52AM Answer ✓

    OK, we have wasted time since you never stated explicitly the release of SQL Developer in use and then, when I inferred it incorrectly, you just went along with it rather than correcting me.  Remember the line from Blade Runner when Harrison Ford hits Rutger Hauer in the head with a pipe?  That hurt!

    Anyway, from the last post (due to the osgi references in the ide.conf file) I see you are actually using a 4.0.x release of SQL Developer.  You need to update the product.conf file with a smaller value of Xmx in order to create an instance of the JVM.  If you haven't found the product.conf file on your system yet, perhaps this will help: http://www.thatjeffsmith.com/archive/2013/12/oracle-sql-developer-4-windows-and-the-jdk/

    If not, ask someone in your IT organization for help -- keep in mind that AppData is one of those hidden Windows directories, so you'll have to tell Explorer to make it visible via the Organize > Folder Options > View > Hidden Files and Folders settings .  Also, you should be using Java 7, not Java 6 -- try to get that upgraded to the latest jdk1.7.0_xx update (currently 60, I believe).  Since you never said if your JDK is 32-bit or 64-bit, I cannot say whether to use a AddVMOption, Add32VMOption, or Add64VMOption.

    Best Wishes,

    Gary

    Message was edited by: Gary Graham

Answers

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    edited Jun 24, 2014 3:37AM

    The blog and forum discussion you reference show the product.conf "location" information for Windows pre-Vista and Vista & higher, respectively.  Unfortunately they do not make perfectly clear that "Adminstrator" and "user", respectively, should be replaced with your username. 

    The product.conf file's owning folder, relative to some environment variables probably available to you, should be:

    1. %APPDATA%\sqldeveloper\1.0.0.0.0
    2. %USERPROFILE%\AppData\Roaming\sqldeveloper\1.0.0.0.0
    
    

    Hope this helps,

    Gary

    SQL Developer Team

    P.S.:  This assumes you are using SQL Developer 4.0.x.  Of course, for older releases, the JDK was set in the installation's sqldeveloper.conf file.

    Message was edited by: Gary Graham

  • Tony007
    Tony007 Member Posts: 4,224 Bronze Trophy
    edited Jun 24, 2014 4:17AM

    i increase the file C:\Users\P9996766\Desktop\sqldeveloper\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

    to

    IncludeConfFile ../../ide/bin/ide.conf

    SetJavaHome C:\Program Files\Java\jdk1.6.0_38

    AddVMOption  -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

    AddVMOption -Dsun.java2d.ddoffscreen=false

    AddVMOption -Dwindows.shell.font.languages=

    AddVMOption  -XX:MaxPermSize=512M

    AddVMOption -Doracle.jdbc.mapDateToTimestamp=false

    AddVMOption -Doracle.ide.startup.features=sqldeveloper

    AddVMOption -Doracle.jdbc.autoCommitSpecCompliant=false

    #Our location for the NLS jars

    AddJavaLibFile  ../../jlib/orai18n-collation.jar

    AddJavaLibFile  ../../jlib/orai18n-mapping.jar

    AddJavaLibFile  ../../jlib/orai18n-servlet.jar

    AddJavaLibFile  ../../jlib/orai18n-utility.jar

    AddJavaLibFile  ../../jlib/orai18n.jar

    IncludeConfFile  sqldeveloper-nondebug.conf

    am still geting error,am on window 7 32 bit

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    edited Jun 24, 2014 4:38AM

    You never indicated which SQL Developer release you use.  Since you decided to update sqldeveloper.conf and use a Java 6 JDK, I assume you are on 3.2.2 or earlier.  In that case, you still need to override the JVM's Xmx value via 

    AddVMOption  -Xmx640M
    
    

    to a lower value that will work on your machine,  either in

    ...\sqldeveloper\bin\sqldeveloper.conf
    
    

    as discussed earlier, or where its default value is set

    ...\ide\bin\ide.conf
    
    

    That should do the trick.

    -Gary

  • Tony007
    Tony007 Member Posts: 4,224 Bronze Trophy

    ok i change C:\Users\P9\Desktop\sqldeveloper\sqldeveloper\ide\bin\ide.conf, must i restart pc after change because am still geting error

    #-----------------------------------------------------------------------------

    #

    # ide.conf - IDE configuration file for Oracle FCP IDE.

    #

    # Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

    #

    # Relative paths are resolved against the parent directory of this file.

    #

    #-----------------------------------------------------------------------------

    IncludeConfFile ../../ide/bin/jdk.conf

    AddJavaLibFile ../../ide/lib/ide-boot.jar

    # All required Netbeans jars for running Netbinox

    AddJavaLibFile  ../../netbeans/platform/lib/boot.jar

    AddJavaLibFile  ../../netbeans/platform/lib/org-openide-util.jar

    AddJavaLibFile  ../../netbeans/platform/lib/org-openide-util-lookup.jar

    AddJavaLibFile  ../../netbeans/platform/lib/org-openide-modules.jar

    # Oracle IDE boot jar

    AddJavaLibFile ../../ide/lib/fcpboot.jar

    SetMainClass oracle.ide.osgi.boot.OracleIdeLauncher

    # System properties expected by the Netbinox-Oracle IDE bridge

    AddVMOption  -Dnetbeans.home=../../netbeans/platform/

    AddVMOption  -Dnetbeans.logger.console=true

    AddVMOption  -Dexcluded.modules=org.eclipse.osgi

    AddVMOption  -Dide.cluster.dirs=../../netbeans/fcpbridge/:../../netbeans/ide/:../../netbeans/../

    # If you are getting the 'Low Memory Warning' Message Dialog while running

    # JDeveloper, please increase the -Xmx value below from the default 800M to

    # something greater, like 1024M or 1250M.  If after increasing the value,

    # JDeveloper is no longer starting up because it fails to create a virtual

    # machine, then please reduce the modified -Xmx value, or use a 64bit JDK

    # which allows for very very large value for -Xmx.

    #

    AddVMOption  -Xmx800M

    AddVMOption  -Xms640M

    # Turn off verifications since the included classes are already verified

    # by the compiler.  This will reduce startup time significantly.  On

    # some Linux Systems, using -Xverify:none will cause a SIGABRT, if you

    # get this, try removing this option.

    #

    AddVMOption  -Xverify:none

    # With OSGI, the LAZY (ondemand) extension loading mode is the default,

    # to turn it off, use any other words, ie EAGER

    #

    AddVMOption  -Doracle.ide.extension.HooksProcessingMode=LAZY

    #

    # Other OSGi configuration options for locating bundles and boot delegation.

    #

    AddVMOption  -Dorg.eclipse.equinox.simpleconfigurator.configUrl=file:bundles.info

    AddVMOption  -Dosgi.bundles=file:../ide/lib/[email protected]:start

    AddVMOption  -Dosgi.bundles.defaultStartLevel=1

    AddVMOption  -Dosgi.configuration.cascaded=false

    AddVMOption  -Dosgi.noShutdown=true

    AddVMOption  -Dorg.osgi.framework.bootdelegation=*

    AddVMOption  -Dosgi.parentClassloader=app

    AddVMOption  -Dosgi.locking=none

    # Needed for PL/SQL debugging

    #

    AddVMOption  -Xbootclasspath/p:../../rdbms/jlib/ojdi.jar

    # Needed to avoid possible deadlocks due to Eclipse bug 121737, which in turn is tied to Sun bug 4670071

    AddVMOption   -Dosgi.classloader.type=parallel

    # Needed for performance as the default bundle file limit is 100

    AddVMOption   -Dosgi.bundlefile.limit=500

    # Make sure the XDK DocumentBuilderFactory is the one used, not Xerces

    AddJavaLibFile  ../../../oracle_common/modules/oracle.nlsrtl_11.2.0/orai18n-collation.jar

    AddJavaLibFile  ../../../oracle_common/modules/oracle.nlsrtl_11.2.0/orai18n-mapping.jar

    AddJavaLibFile  ../../../oracle_common/modules/oracle.nlsrtl_11.2.0/orai18n-servlet.jar

    AddJavaLibFile  ../../../oracle_common/modules/oracle.nlsrtl_11.2.0/orai18n-utility.jar

    AddJavaLibFile  ../../../oracle_common/modules/oracle.nlsrtl_11.2.0/orai18n.jar

    AddJavaLibFile  ../../modules/oracle.xdk_12.1.2/xmlparserv2.jar

    AddVMOption -Djavax.xml.parsers.DocumentBuilderFactory=oracle.xml.jaxp.JXDocumentBuilderFactory

    AddVMOption -Djavax.xml.parsers.SAXParserFactory=oracle.xml.jaxp.JXSAXParserFactory

    AddVMOption -Dorg.xml.sax.driver=oracle.xml.parser.v2.SAXParser

    # Configure location of feedback server (Oracle internal use only)

    AddVMOption -Dide.feedback-server=ide.us.oracle.com

    # For the transformation factory we take a slightly different tack as we need to be able to

    # switch the transformation factory in certain cases

    #

    AddJavaLibFile ../../ide/lib/xml-factory.jar

    AddVMOption -Djavax.xml.transform.TransformerFactory=oracle.ide.xml.switchable.SwitchableTransformerFactory

    # Override the JDK or XDK XML Transformer used by the SwitchableTransformerFactory

    # AddVMOption -Doracle.ide.xml.SwitchableTransformer.jdk=...

    # Pull parser configurations

    AddJavaLibFile  ../../ide/lib/woodstox-core-asl-4.1.1.jar

    AddJavaLibFile  ../../ide/lib/stax2-api-3.1.1.jar

    AddVMOption -Djavax.xml.stream.XMLInputFactory=com.ctc.wstx.stax.WstxInputFactory

    AddVMOption -Djavax.xml.stream.util.XMLEventAllocator=oracle.ideimpl.xml.stream.XMLEventAllocatorImpl

    # Enable logging of violations of Swings single threaded rule. Valid arguments: bug,console

    # Exceptions to the rule (not common) can be added to the exceptions file

    AddVMOption -Doracle.ide.reportEDTViolations=bug

    AddVMOption -Doracle.ide.reportEDTViolations.exceptionsfile=./swing-thread-violations.conf

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown
    edited Jun 24, 2014 5:52AM Answer ✓

    OK, we have wasted time since you never stated explicitly the release of SQL Developer in use and then, when I inferred it incorrectly, you just went along with it rather than correcting me.  Remember the line from Blade Runner when Harrison Ford hits Rutger Hauer in the head with a pipe?  That hurt!

    Anyway, from the last post (due to the osgi references in the ide.conf file) I see you are actually using a 4.0.x release of SQL Developer.  You need to update the product.conf file with a smaller value of Xmx in order to create an instance of the JVM.  If you haven't found the product.conf file on your system yet, perhaps this will help: http://www.thatjeffsmith.com/archive/2013/12/oracle-sql-developer-4-windows-and-the-jdk/

    If not, ask someone in your IT organization for help -- keep in mind that AppData is one of those hidden Windows directories, so you'll have to tell Explorer to make it visible via the Organize > Folder Options > View > Hidden Files and Folders settings .  Also, you should be using Java 7, not Java 6 -- try to get that upgraded to the latest jdk1.7.0_xx update (currently 60, I believe).  Since you never said if your JDK is 32-bit or 64-bit, I cannot say whether to use a AddVMOption, Add32VMOption, or Add64VMOption.

    Best Wishes,

    Gary

    Message was edited by: Gary Graham

  • Tony007
    Tony007 Member Posts: 4,224 Bronze Trophy

    i add this it works thanks

    Add32VMOption  -Xmx800M

    Add32VMOption  -Xms640M

    my java version is

    C:\Users\P9\Desktop\sqldeveloper\sqldeveloper\sqldeveloper>java -version

    java version "1.7.0_55"

    Java(TM) SE Runtime Environment (build 1.7.0_55-b14)

    Java HotSpot(TM) Client VM (build 24.55-b03, mixed mode, sharing)

  • Gary Graham-Oracle
    Gary Graham-Oracle Member Posts: 3,256 Bronze Crown

    Excellent -- very happy to know your configuration is now correct and also up-to-data with respect to the JDK,

This discussion has been closed.