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

cd /to/tora/tarball
tar xf tora-2.1.2.tar.bz2
cd tora-2.1.2

Environment Variables

vi ~/.bashrc
+ # Oracle 10g Standard Edition
+ export ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/db_1
+ 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 \

You should see in the logs: “checking for oracle… yes

make install

Then you can start Tora: