Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

unable to create an instance of the java virtual machine

Tony007Jun 24 2014 — edited Jun 24 2014

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

This post has been answered by Gary Graham-Oracle on Jun 24 2014
Jump to Answer

Comments

Gary Graham-Oracle Jun 24 2014 — edited on Jun 24 2014

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 Jun 24 2014 — edited on Jun 24 2014

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 Jun 24 2014 — edited on Jun 24 2014

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 Jun 24 2014

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/oracle.ide.osgi.jar@3: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 Jun 24 2014 — edited on Jun 24 2014
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

Marked as Answer by Tony007 · Sep 27 2020
Tony007 Jun 24 2014

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 Jun 24 2014

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

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 22 2014
Added on Jun 24 2014
7 comments
20,270 views