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.

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

  • In order to retain PostgreSQL and MySQL support, development packages for those are also required:

  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/rules

  change 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/11.1.0.1/client --without-kde --without-rpath --disable-new-check --enable-libsuffix=

• Now you're ready to build. First become root:

  sudo -i

• If ORACLE_HOME is not already set, point it to the appropriate place:

  export ORACLE_HOME=/usr/lib/oracle/11.1.0.1/client

• 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;

• this page, which was a bit outdated; and this entry on Ubuntuforums.

CategorySoftware