4 Replies Latest reply: Aug 13, 2013 9:19 PM by Catch-22 Branched to a new discussion. RSS

    Oracle SQL Developer 3.x on Linux Ubuntu 11.10 how-to

    Catch-22

      Author: Dude


      Please note:

       

      This information is presented under the terms of using the Oracle Web sites: http://www.oracle.com/us/legal/terms/index.html. You may use it for the purpose of reference, presentation or education, provided it is not redistributed under a different name or author, and available for free and not for profit. Any other use will require my explicit permission. This information is presented in the hope that it will be helpful. Use at your own risk.

       

      Should you experience problems with these instructions, please feel free to add a note with the link to your own discussion. However, please do not use this thread to troubleshoot or explain your issues. Thanks!

       

       

      History

       

      26-Oct-2011: First release.
      30-Nov-2011: Cosmetic changes.
      14-Aug-2013: Correcting formatting issues due to forum update. Some text changes.

      05-Sep-2013:  Correcting line endings to avoid cut and paste issues with blank lines (Firefox).

                                  Adding note about installing on 32-bit (i386) OS.

       


      Preface

      This document outlines step by step instructions how to install Oracle SQL-Developer 3.x on Ubuntu 11.10 and has been tested using Oracle SQL-Developer 3 (Production) and 3.1 (Early Adapter).

       

       

      Topics overview


      1. Install Linux Ubuntu
      2. Install Java JDK
      3. Install Oracle SQL Developer
      4. Configure Path to Java
      5. Create Unity Launcher
      6. Troubleshooting



      1. Install Linux Ubuntu

       

      The following assumes you have installed Ubuntu 11.10 Desktop Edition for 32-bit or 64-bit, or upgraded from a previous version. You can download Ubuntu for free at: http://www.ubuntu.com/download/ubuntu and install it using the default settings provided.

      Note: You should apply the latest OS patch-sets by clicking the power button icon in the upper right hand corner of the screen and selecting "Software Up To date & Check" or "Updates available..."


      2. Install Java JDK


      Oracle SQL Developer requires Java SDK. Open a Terminal command prompt (Ctrl-Alt-t) and enter the following:

       

      Terminal

      sudo apt-get install openjdk-6-jdk

       


      3. Install Oracle SQL Developer


      Download Oracle SQL Developer for other platforms from http://otn.oracle.com/developer-tools/sql-developer/downloads.

      Then enter the following commands:

      Note: You may need to change filename according to the current available version.

       

      Terminal

      cd ~/Downloads
      filename=sqldeveloper-3.1.05.97-no-jre.zip
      unzip $filename -d $HOME/Applications
      rm $file
      chmod 750 $HOME/Applications/sqldeveloper/sqldeveloper.sh

       


      4. Configure Path to Java


      SQL-Developer needs to know how to find your Java Developer Kit:

       

      Note: You need to specify /usr/lib/jvm/java-6-openjdk-i386 on 32-bit OS installations.

       

      Terminal

      cd $HOME
      mkdir -p .sqldeveloper
      cd $HOME/.sqldeveloper
      echo "/usr/lib/jvm/java-6-openjdk" > jdk

       


      5. Create Unity Launcher

      Cut & paste the following into a terminal command prompt in order to register the SQL Developer Launcher:

       

      Terminal

      cd $HOME/Applications/sqldeveloper

       

      Cut and past the following into the terminal window:

       

      Terminal

      cat > sqldeveloper.desktop <<EOF
      [Desktop Entry]
      Exec=$HOME/Applications/sqldeveloper/sqldeveloper.sh %U
      Terminal=false
      StartupNotify=true
      Categories=GNOME;Oracle;
      Type=Application
      Icon=$HOME/Applications/sqldeveloper/icon.png
      Name=Oracle SQL Developer
      EOF

       

      Continue as following:

       

      Terminal

      sudo cp sqldeveloper.desktop /usr/share/applications
      sudo update-desktop-database

       

      You can create a SQL Developer Launcher icon on your Desktop by selecting the Ubuntu Logo icon, located at the top of the Unity dock, then type "sql" in the search field and drag the found icon to your desktop.


      6. Troubleshooting


      The following allows to activate or deactivate terminal output in order to troubleshoot SQL Developer.

      Terminal

      sed -i 's/Terminal=false/Terminal=true/g' ~/Desktop/sqldeveloper.desktop

       

      or switch it off:

       

      Terminal

      sed -i 's/Terminal=false/Terminal=false/g' ~/Desktop/sqldeveloper.desktop

       


      Kind regards and best of luck!

      Dude.