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