Configure ORACLE_HOME for SQL Developer

The release V4.0 of sql developer is available for download : oracle.com/technetwork/developer-tools/sql-developer/downloads
The doc is there : docs.oracle.com/cd/E39885_01/index.htm

And read Jeff Smith twit’s and blog

I requested some time ago a 64bit Windows version with JDK on Oracle SQL Developer Exchange and once again it got accepted.

Okay, I have on my PC two Oracle homes : one for 32 bits and one for 64 bits. The 32 bits is first in PATH.

When I start SQL Developer, I could not use the OCI thick driver which is required when connecting via LDAP or TNSNAMES. SQL Developer was failing with error :
ocijdbc11.dll: Can't load IA 32-bit .dll on a AMD 64-bit platform

Apart from changing the path in the Environment variables or in .bat file, it is possible to add the following line in sqldeveloper/bin/sqldeveloper.conf (where dbhome_2 is a 64bits home):
AddVMOption -Djava.library.path=C:\oracle\product\12.1.0\dbhome_2\bin

If you need to connect to Sybase ASE (or MSSQL), download the driver here : http://sourceforge.net/projects/jtds and add it as Datasbase/Third-Party Driver

For MySQL go there : http://dev.mysql.com/downloads/connector/j/ and download the Platfrom Independant ZIP file.

3 thoughts on “Configure ORACLE_HOME for SQL Developer

  1. William Robertson

    Might be worth mentioning that you can copy sqldeveloper.conf to %APPDATA%\sqldeveloper\[version] if the original is in a read-only folder. Also in later versions there is a option to set the path for the Oracle Client in Tools > Preferences > Database > Advanced, although it seems sqldeveloper.conf is still useful for overwriting the default java.library.path.

  2. Laurent Schneider Post author

    Indeed setting up oracle client doesn’t solve the 32/64 bit confusion… sql dev shall look in registry not in path for the home.
    Thanks for the hint about appdata, very usefull indeed

Comments are closed.