Before you go crazy trying to configure Tora or Toad or other SQL editors for Linux, try this nice (as in free) SQL editor for Oracle (Windows/Linux/Mac):
http://www.oracle.com/technology/software/products/sql/index.htmlInstallation notes for Ubuntu (i'm nOOb on Linux, but this worked for me):
1. Make sure you have the "alien" package installed on your pc
- Codice:
-
sudo apt-get install alien
2. After you finish downloading the
sqldeveloper-*.rpm file transform it into a .deb by typing
- Codice:
-
sudo alien --script sqldeveloper-*.rpm
3. Install the newly created .deb file:
- Codice:
-
sudo dpkg -i sqldeveloper_*.deb
That should do it! You now have a nice icon in the
Programming menu.
If you click it and nothing happens open a console and type
- Codice:
-
sqldeveloper
. If it's asking for the homepath of your JDK installation do the following:
1. Locate the installation folder of your SqlDeveloper (should be /home/
userName/.sqldeveloper/ but in my case was /opt/sqldeveloper/ so check there too).
2. In the file /sqldeveloperInstallationFolder/sqldeveloper/bin/
sqldeveloper.conf add
SetJavaHome /usr/lib/jvm/java-6-sun-*happy coding!
*-replace with version number