Ubuntu and Oracle SQL Developer
A few days ago, tired of the constant Conficker infections and strong of the fact that my pc is a simple workstation from which I connect to the real machines I work with (a mixture of Windows Server 2003 and GNU / Linux environments, real and virtualized ), I thought about formatting my PC running Windows XP to upgrade to Ubuntu 8.10.
A tool that I have been using for some time now and that gives me the same satisfaction as Toad (but in addition, it is free and does not require licenses) is Oracle SQL Developer. This software is made in Java so it is available for several platforms, including GNU / Linux, although there is no deb package for Debian and Debian like distributions. If you want, you can use the Alien tool to convert the rpm into a deb, or you can always download a zip file containing the entire environment ready for use.
The version for GNU / Linux does not come with the Java SDK, which is necessary to run the SQL Developer interface, but with Ubuntu 8.10, for example, you can easily remedy the lack with:
$ sudo aptitude install sun-java6-jdk
Assuming you want to use the zip file provided by Oracle, you can unpack it, for example, in / usr / src /:
$ tar xzf sqldeveloper-1.5.4.59.40-no-jre.zip
$ sudo mv sqldeveloper / usr / src /
The script to be launched is contained in / usr / src / sqldeveloper (the path must be adapted according to the installation directory chosen):
$ cd / usr / src / sqldeveloper
$ ./sqldeveloper.sh
However, you may notice an error message appearing on the terminal:
Oracle SQL Developer
Copyright (c) 2008, Oracle. All rights reserved.
Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~ / .sqldeveloper / jdk
In this case, you have to finish creating the script with Ctrl-C, then create a directory called .sqldeveloper (pay attention to the point before the name, as it is a hidden directory) in your home and within this directory create a file called jdk . This file must contain the path to the jvm so:
$ mkdir /home/username/.sqldeveloper
$ cd ~ / .sqldeveloper
$ touch jdk
$ echo / usr / lib / jvm / java-6-sun> jdk
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert. This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.