SQLDev, Ubuntu

Install SQL Developer on Ubuntu 17.04

ubuntu logoLast week I decided to blow away Windows on my ASUS laptop and install a flavor of #Linux. I’ve got a few machines running Oracle Linux so I settled on #Ubuntu. To be more specific:

dbryant@asus:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 17.04
Release: 17.04
Codename: zesty

As a person that spends a significant amount working in the Oracle database, I really needed to get #SQLDeveloper going. Unfortunately, the Linux RPM version won’t work so I need to go grab the ‘Other Platforms’ version for this install. At the time of this post, the current version is sqldeveloper-17.2.188.1159-no-jre.zip. So go ahead and download that from the Oracle OTN Downloads site. You will need to either login or create a free account to complete the download. While you are downloading, you may need to go ahead and install JAVA by issuing the following commands:

Once the SQL Developer zip file downloads execute the following steps to unzip the file in the proper location in the file system:

Now lets make a small edit to the sqldeveloper.sh script

Change the line above to:

You can now launch SQL Developer:

When you first run SQL Developer, you will be prompted for the path to the JDK installation.

Copy and paste this: /usr/lib/jvm/java-1.8.0-openjdk-amd64 in the dialog box.

At this point, you should have a successful launch of SQL Developer in #Ubuntu 17.04

ubuntu_sqldev

Enjoy!dbaontap


Also published on Medium.