How to install Oracle 10g and Tora on GNU Linux Ubuntu Karmic 9.10
Thanks to my collegue Gaël Pegliasco, I successfully installed Oracle 10g Full Edition on my Ubuntu Karmic 9.10 (64 bits). We will see now how to install Tora, an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle.
Installing Oracle 64 bits
See this wonderfull howto written by Gaël Pegliasco which explains how to install Oracle 10g 64 bits.
Now we assume your ORACLE_HOME is "/opt/oracle/oracle/product/10.2.0/db_1".
IMPORTANT: your user must have access to the ORACLE_HOME files.
Installing Tora
Install the prerequisites and development libraries
sudo apt-get install build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl sudo apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev sudo apt-get install debhelper dpatch texinfo sudo apt-get install libaio1
Dowload Tora from Sourceforge
http://sourceforge.net/projects/tora/files/
cd /to/tora/tarball tar xf tora-2.1.2.tar.bz2 cd tora-2.1.2 mkdir INSTALL_DIR
Environment Variables
vi ~/.bashrc + # Oracle 10g Standard Edition + export ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/db_1 + export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib + export PATH=$PATH:$ORACLE_HOME/bin + export ORACLE_SID=orcl source ~/.bashrc
sudo vi /etc/ld.so.conf.d/oracle.conf + /opt/oracle/oracle/product/10.2.0/db_1/lib sudo ldconfig
Include path oddity
Thanks to Brad Hudson !
sudo ln -s /opt/oracle/oracle/product/10.2.0/db_1/ ${ORACLE_HOME}/include
Building and installing TOra
./configure --exec-prefix=/home/sbo/Logiciels/tora/tora-2.1.2/INSTALL_DIR \ --prefix=/home/sbo/Logiciels/tora/tora-2.1.2/INSTALL_DIR
You should see in the logs: "checking for oracle... yes"
make make install
Then you can start Tora:
./INSTALL_DIR/bin/tora