Tuesday, January 21, 2014

How Install the Oracle SQL Developer on Ubuntu

I was searching to install SQL Developer for my Ubuntu machines. Since the oracle SQL Developer install is not in Ubunutu's repository, So I ended up with downloading the "rpm" installation from Oracle's Web Site.


Once i downloaded the installation file

1) First install alien:
sudo apt-get install alien

2) Then, convert the rpm file to a deb file:
sudo alien --scripts -d sqldeveloper-4.0.0.13.80-1.noarch.rpm

3) Then we run the deb file generated
sudo dpkg -i sqldeveloper_4.0.0.13.80-2_all.deb

4) Create the following directory in your home folder, this where it's going to store path to the jdk in the next step:
mkdir .sqldeveloper/

5) Run sqldeveloper once from the terminal
sudo /opt/sqldeveloper/sqldeveloper.sh

6) Once you run this (5) first time go to directory that is created in (4) and make the changes
Enter the full path to Java 7

If you've got the openjdk, it'll be:
/usr/lib/jvm/java-7-openjdk

For the official one it'll be:
/usr/lib/jvm/java-7-sun


Note that Oracle SQL Developer requires JAVA 7