Oracle SQL Developer in Ubuntu
You will need a free Oracle account to log in and download SQL Developer from Oracle Technology Network site. For ubuntu download the Other Platforms version. At the time of writing this post, I download version is sqldeveloper-17.2.0.188.1159-no-jre.zip. You will also need Java to run Oracle SQL developer.
After download, I moved the download file to /home/rimonmostafiz/Applications
(you can choose any other location you prefer).
Move the download file to /home/rimonmostafiz/Applications
. you can choose any other location you prefer.
$ sudo mv sqldeveloper-17.2.0.188.1159-no-jre.zip /home/rimonmostafiz/Applications
$ cd /home/rimonmostafiz/Applications
$ sudo unzip sqldeveloper-17.2.0.188.1159-no-jre.zip
Next link over an in-path launcher for Oracle SQL Developer
$ sudo ln -s /home/rimonmostafiz/Applications/sqldeveloper/sqldeveloper.sh /bin/sqldeveloper
$ sudo rm /usr/local/bin/sqldeveloper*.zip
Edit /home/rimonmostafiz/Applications/sqldeveloper/sqldeveloper.sh
and replace it’s content to:
#!/bin/bash
unset -v GNOME_DESKTOP_SESSION_ID
cd /home/rimonmostafiz/Applications/sqldeveloper/sqldeveloper/bin
./sqldeveloper "$@"
If ./sqldeveloper
permission denied error occurs
Try this
#!/bin/bash
unset -v GNOME_DESKTOP_SESSION_ID
cd /home/rimonmostafiz/Applications/sqldeveloper/sqldeveloper/bin && bash sqldeveloper $*
Now run sql developer by typing command
$ sqldeveloper
Note: When you run Sql Developer at the first time, you need to specify the path of JDK’s folder. In my computer, JDK stored at
/home/rimonmostafiz/.sdkman/candidates/java/8u152
I prefer use SDKMAN to manage my different versions of java. You can read details about SDKMAN from My Manage JDK using SDKMAN post.**
Now we can create a desktop application for easy to use:
$ cd /usr/share/applications/
$ sudo vim sqldeveloper.desktop
then add the following lines to the file
[Desktop Entry]
Exec=sqldeveloper
Terminal=false
StartupNotify=true
Categories=GNOME;Oracle;
Type=Application
Icon=/home/rimonmostafiz/Applications/sqldeveloper/icon.png
Name=Oracle SQL Developer
Finally run
$ sudo update-desktop-database
Now you will find Oracle SQL Developer in your app launcher.
- Ubuntu Verson:
16.04 LTS
- JDK Verison:
1.8
- SQL Developer Version:
sqldeveloper-17.2.0.188.1159-no-jre.zip