Installing Tora with Oracle Support
The "tora" database client package in FeistyFawn comes with Postgres support, and MySQL if you have the libraries. This How-To shows you how to build Oracle Instantclient 10g support into tora.
This is client only. You will not install the whole Oracle database.
BTW, if you don't have time to build the whole thing, here is the .deb package I built using this How-To. It's x386 only, and you'll need to have instantclient installed before you can use it.
tora_1.3.22-5_i386.deb is an updated .deb package for instantclient 220.127.116.11 and tora 1.3.22.
tora_1.3.23-1_amd64.deb is an updated .deb package for 64-bit instantclient 18.104.22.168.0 and tora 1.3.23
NOTE: Packages for more recent Ubuntu versions may be found on Launchpad, please also note that /etc/ld.so.conf.d/oracle.conf must be created instead of setting LD_LIBRARY_PATH since Ubuntu 9.04 (see Help).
First Step: Install Oracle Instantclient
The instructions for this stage are on the page Oracle Instant Client. The Oracle Client SDK is needed to build Tora.
When sqlplus is working correctly, move on to compiling "tora"
Second Step: Build Tora
- Install some required libraries:
apt-get install build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev apt-get install debhelper dpatch texinfo
On LucidLynx, building tora-2.1.1, the following packages are also needed:
apt-get install cdbs cmake apt-get install qt-qmake libqt4-dev apt-get install libqscintilla2-dev
apt-get install postgresql-dev libmysqlclient-dev
- Download the tora source code:
sudo apt-get source tora
Edit some build lines for Instantclient (not required for tora-2.1.1 on LucidLynx):
cd /usr/src/tora-1.3.21 sudo vi debian/ruleschange the line:
./configure --prefix=/usr --without-oracle --without-rpath --disable-new-check --with-kde --enable-libsuffix=to look like this:
./configure --prefix=/usr --with-instantclient --with-oracle-includes=/usr/include/oracle/22.214.171.124/client --without-kde --without-rpath --disable-new-check --enable-libsuffix=
- Now you're ready to build. First become root:
- If ORACLE_HOME is not already set, point it to the appropriate place:
- Then build:
cd /usr/src/tora-1.3.21 debian/rules binary
If all goes well, after a "'long'" time, you should end up with a file in /usr/src called "tora_1.3.21-3ubuntu1_i386.deb". You can install it like this:
dpkg -i tora_1.3.21-3ubuntu1_i386.deb
If dpkg gives an error like so:
tora depends on libqt3-mt-psql | libqt3-mt-odbc | libqt3-mt-mysql; however: Package libqt3-mt-psql is not installed. Package libqt3-mt-odbc is not installed. Package libqt3-mt-mysql is not installed.
you can have apt fix its dependencies like so (afterwhich running the above dpkg -i command again should work):
apt-get -f install
Step Three: Using Tora to connect to an Oracle database
- Start "tora".
In the connect box make sure the connection provide says "Oracle. Then enter an Instantclient connect string in the boxes. Put "username" and "password" in the appropriate places. Then put the string //dbhost:<portno>/SID in the "Database" box. Here is a picture.
This How-To owes thanks to this page from Ben Pinter;