Oracle SQL Developer on Ubuntu 10.04 and 12

After messing about for a couple of days using folders, SQLPlus and my own sad excuse for code-control, I decided to download Oracle SQL Developer and learn to use it. My big issue though, is that I use Ubuntu Linux on my desktop (Ubuntu 12) and my laptop (Ubuntu 10.04), so it was always going to be an interesting build.

I've put off this installation since moving from Windows as I knew some people had issues with the de-support of the JRE on Ubuntu by Oracle. After messing about using several different web sites and having to change my translations from forum sites (not everyone has English as their first language!) into hard instructions, I finally got it working on my laptop.

I filtered the instructions into a file then ran them against my desktop. I had one small edit and the result is here for you to have.

Let me know if it helps.

Phiz

1. Sign up with Oracle Technical Network and go to download page - http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html
2. Accept License Agreement
3. Use link Oracle SQL Developer for other platforms (This zip does not include a JDK) for download.
4. Use Ubuntu Software Center and download and install Java (as Oracle no longer provide a JRE for Ubuntu, use java-6-openjdk)
5. Edit the ~/.bash_profile file and include the following two lines:
   export JAVA_HOME=/usr/lib/jvm/java-6-sun
   export PATH=$PATH:$JAVA_HOME/bin
6. Create a directory in home directory to hold the binaries – mine was /home/phiz/sqldeveloper
7. Copy the downloaded file to the new directory
8. Unzip the file in the new directory unzipsqldeveloper-”version_number”-no-jre.zip
9. Change the privs on the directory and files

   $ chmod -R a+rwx sqldeveloper

10. Add the menu bar icon and make sure it works! Enter the following lines at the prompt as they are here:

    cat > sqldeveloper.desktop <<EOF

                 [Desktop Entry]
    

    Exec=/usr/local/SQLDev/sqldeveloper/sqldeveloper.sh %U

    Terminal=false

    StartupNotify=true

    Categories=GNOME;Oracle;

    Type=Application

    Icon=/usr/local/SQLDev/sqldeveloper/icon.png

    Name=Oracle SQL Developer

    EOF

11. Move to the source directory you created earlier:

    $ cd sqldeveloper 

12. Run the startup script
              ./sqldeveloper.sh 
13. At the prompt to add the location of Java I added my install location:
              /usr/lib/jvm/java-1.6.0-openjdk 

Bingo! Now you are running Oracle SQL Developer.

I'd be pleased to have your feedback.

Successful evening at Shropshire LUG, Telford

I hadn't expected the Shropshire LUG people to be sun-worshippers, but it seems the good weather kept many away, and they missed a treat! We advertised it as the tech-equivalent of the Frost-Nixon interview, but it turned out more Corbett-Cleese in the end!

Knowledge becomes power only when we put it into use

I suppose it’s a bit like being in a car and watching the speedometer steadily increase until you are going far too fast and then discovering that the brakes are on the passenger’s side!

Online Backup Services Case Studies

Jumbo is pleased to announce that case studies for their new Asigra based online backup services are now available for download. No logins required so please feel free to browse!

Latest press release - Jumbo's new online backup services

Keeping in line with our ethos of "Getting better for less from your IT environment", Jumbo's new online backup services provide fast and configurable management allowing backups as required and swift recovery. Please see latest press release about online backup services.

Whitepaper - Basics for Database Technology - Backup and Recovery

The second whitpaper in Phiz's series is now available for download. Based on true stories, it illustrates how essential it is to business not only to be able to backup but also to be able restore efficiently. Read now...

It is fundamental to today's IT driven world that data is saved to backup from where it can be restored should anything go wrong. Many businesses small and large have thrived from the massive industry that now exists in order to fulfil the needs of the ever-increasing data load to be backed up.

Be sure to get your comments back to Phiz through posting your comments below.

Our latest whitepapers can be found on Jumbo IT Services website or by clicking the whitepapers tab opposite.

The problem with emergency drills

What’s wrong with emergency drills?

Probably we’ve all, at some point in time, had to take part in an emergency drill. The inconvenient fire drill, the lifeboat drill or the restore from backup (I hope you have all practised this one).

What’s wrong with emergency drills? Well almost without exception there is one thing missing;

THE EMERGENCY!

We all react differently to situations and when we are practising in a controlled manner, some of us tend to do things correctly, while others are rather blasé about the whole thing and yet others do it because they have to but believe it will never happen to them.