App Muncher

Issues faced - solutions identified - shared with community.

I was running Windows 7 32 bit and was trying to run Oracle Sql Developer.
The java version installed on my machine was :
C:\Users\ralhana>java -version
java version "1.8.0_60"
Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
Java HotSpot(TM) Client VM (build 25.60-b23, mixed mode, sharing)

On running the installer i came across the error "Unable to launch java virtual machine located at path".

SQL Developer was unable to find the java version available on local machine to run.
The installer was 64 bit, and the windows version was 32 bit.

To resolve the issue i made changes to the Sql Developer configuration and specified the java version available.

Edit the “sqldeveloper.conf“, which can be found under “{ORACLE_HOME}\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf“, make sure “SetJavaHome” is pointing to your 32 bits JDK.

For example, “SetJavaHome C:\Program Files (x86) \Java\jdk1.7.0_51“.


My configuration file is as follows:


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

SetJavaHome ../../jdk

#Set our usage tracking URI
AddVMOption -Dide.update.usage.servers=http://www.oracle.com/webfolder/technetwork/sqldeveloper/usage.xml

#Disable the AddinPolicyUtils
AddVMOption -Doracle.ide.util.AddinPolicyUtils.OVERRIDE_FLAG=true

#Draw performance change
AddVMOption -Dsun.java2d.ddoffscreen=false

#font performance
AddVMOption -Dwindows.shell.font.languages=

#Update the size of the perm gen area
AddVMOption -XX:MaxPermSize=256M

AddVMOption -Doracle.ide.startup.features=sqldeveloper

AddJavaLibFile ../lib/oracle.sqldeveloper.homesupport.jar
AddVMOption -Doracle.ide.osgi.boot.api.OJStartupHook=oracle.dbtools.raptor.startup.HomeSupport

#Configure some JDBC settings

AddVMOption -Doracle.jdbc.mapDateToTimestamp=false
AddVMOption -Doracle.jdbc.autoCommitSpecCompliant=false
# The setting below applies to THIN driver ONLY for others set this to false.
# Refer to OracleDriver doc. for more info.
AddVMOption -Doracle.jdbc.useFetchSizeWithLongColumn=true
AddVMOption -Dsun.locale.formatasdefault=true
AddVMOption -Dorg.netbeans.CLIHandler.server=false

IncludeConfFile sqldeveloper-nondebug.conf

SetJavaHome C:\Program Files\Java\jdk1.7.0_51\

No comments:

Post a Comment

| Designed by AppMuncher