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-

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

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:

For the official one it'll be:

Note that Oracle SQL Developer requires JAVA 7