Using SQL Developer off campus on Fedora 25 Linux

sqldeveloper-fedora25.rst

VPN access

In a terminal:

sudo openconnect --juniper uhvpn.herts.ac.uk

It'll ask for credentials. Staff will use: <your studynet id>@staff while students will use: <your studynet id>@student

If the openconnect command isn't available, the "openconnect" package needs to be installed:

sudo dnf install openconnect

Obtaining and running SQLDeveloper

SQLDeveloper needs to be downloaded and some things configured for it to work correctly.

Downloading SQLDeveloper

Download SQLDeveloper from this page. You'll need to accept the license and create an account. Download the "Other platforms" variant. This will download a zip file like this: sqldeveloper-4.1.5.21.78-no-jre.zip

Once it's on your system, extract the zip file:

cd /path/to/downloaded/zip/file
unzip sqldeveloper-4.1.5.21.78-no-jre.zip

This will create a new sqldeveloper folder.

JDK

SQLDeveloper works with OpenJDK. To ensure that OpenJDK is installed, run:

sudo dnf install java-1.8.0-openjdk-devel

Running SQLDeveloper

Connect to the VPN as documented above and ensure that OpenJDK is installed. Then, you should be able to run SQLDeveloper:

cd /path/to/sqldeveloper/folder
./sqldeveloper.sh

The first time it runs, it'll ask for a Java path. Enter this: /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.111-1.b16.fc25.x86_64/. Note that this path may vary. Check /usr/lib/jvm/ to see what the correct path is. It should contain a /bin/java file.

If things were done correctly, SQLDeveloper will run and one can make a new connection as described in the SQL workbook.