Tuesday, April 28, 2009

Foundation To Cover Acne For Wedding

Ubuntu and Oracle SQL Developer

few days ago, tired of the constant infections Conficker strong and the fact that my pc is a simple workstation from which I connect on the machines I work with real (a mixture of Windows Server 2003 environments and GNU / Linux, real and virtualized), I decided to format my Windows XP PC that was equipped to switch to Ubuntu 8.10.

One tool I use for some time now and that gives me the same satisfaction of Toad (but more is free and does not require licenses) is Oracle SQL Developer. This software is written in Java so it's available for several platforms, including GNU / Linux, even if there is a deb package for Debian and Debian distributions like. If you want you can use the Alien tool to convert the rpm in deb, or you can always download a zip file containing the entire environment ready for use.

version for GNU / Linux comes with the Java SDK, needed to run the SQL Developer interface, but with Ubuntu 8.10, for example, you can easily remedy the deficiency with: $ sudo aptitude install
sun-java6-jdk

Suppose you want to use the zip file provided by Oracle, you can unpack, for example, in / usr / src /: $ tar xzf
sqldeveloper-1.5.4.59.40-no-jre.zip
sqldeveloper $ sudo mv / usr / src /

The script to run is in / usr / src / sqldeveloper (the path is to be adapted depending on the chosen installation directory):
$ cd / usr / src / sqldeveloper
$. / sqldeveloper.sh

However, you may notice the appearance on the terminal of an error message: 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 the creation of the script with Ctrl-C, and then create a directory called . Sqldeveloper (attention to the point of first name, because it is a hidden directory) in your home and all ' inside this directory create a file called jdk . This file must then contain the path to the jvm:
$ mkdir / home / username / .sqldeveloper
$ cd ~ /. Sqldeveloper
jdk
$ echo $ touch / usr/lib/jvm/java-6-sun> jdk

After that you can start SQL Developer with confidence!

0 comments:

Post a Comment