We will see how to install Tora on Ubuntu Karmic 9.10 , an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle 10g Full Edition.

Prerequisites : Oracle 64 bits is installed

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