Wednesday, 23 December 2009

Install Tora on Ubuntu 9.10

Tora is client for oracle like Toad.

OS: Ubuntu 9.10
Tora version: 2.2.0
Oracle client version:

Download oracle client packages for linux from

Install alien for rpm packages on Ubuntu
# sudo apt-get install alien

Install oracle client packages.
# sudo alien -i oracle-instantclient-basiclite-
# sudo alien -i oracle-instantclient-sqlplus-
# sudo alien -i oracle-instantclient-devel-

Edit /etc/
# sudo vi /etc/
add this line /usr/lib/oracle/
# sudo ldconfig
# sudo apt-get install libaio1

run sqlplus and see it is working.
# sqlplus
SQL*Plus: Release - Production on Tue Dec 22 10:06:27 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name

Building TORA
Continue as root
# sudo -i
Get packages for compiling.
# apt-get build-dep tora
# apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl debhelper alien libaio1 dpatch fakeroot xsltproc texi2html texinfo libqt3-mt-psql libqt3-mt-odbc config-package-dev cmake qt4-dev-tools
# cd tora-2.0.0
Environment variables also add this lines to your users .bashrc file.
# export ORACLE_HOME="/usr/lib/oracle/"
# ln -s /usr/include/oracle/ ${ORACLE_HOME}/include
# debian/rules binary
# dpkg -i ../tora_2.0.0-4build2_i386.deb

Now you can run Tora. Log out and log in to be sure you set environment variables. Also put your tnsnames.ora here /usr/lib/oracle/

No comments: