Sqldeveloper not working with Oracle11gR2 database on 64 bit windows 7

When installing Oracle11gr2 database in a 64 bit windows machine, we might encounter an issue  where in the Sql Developer  that comes along with it doesn’t work. 

This is because the sqldeveloper coming along with the 11gR2 version of the Oracle Databse doesn’t support the 64 bit OS.

 

sqldeveloper.exe is a 32-bit exe that is being shipped on Windows 64-bit and it cannot load the jdk dll's.

So how do we solve this?

Simply download the version 2.1 of Oracle SQL Developer Oracle Technology Network

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

The version 2.1 is documented as supporting 64- bit Windows platform.

Once the 64- bit sqldeveloper is doqnloaded and the java path is provided, it works perfectly.

Have a nice day!

-Gautam