Tora w/ Oracle support on Ubuntu 7.10

Tora from the ubuntu repository doesn't include oracle support because of the license.

So, in order to get tora to work right, we have to compile it from scratch.

1. Install Oracle Instant Client

You can get it from : http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html

Grab the Basic, SDK, and sqlplus and unzip them all into /usr/local/oracle

2. soft link any libraries with a suffix that's not .so as .so (libocci.so.10.1 --> libocci.so)

3. make a bin directory and link sqlplus into it

4. copy the tnsnames.ora file from the database into it

5. Modify ~/.bashrc and export ORACLE_HOME to match the /usr/local/oracle/instantclient_XX_X directory

Export TNS_ADMIN as the same directory

7. add the instantclient directory to /etc/ld.so.conf and run ldconfig

8. try and connect to the database with sqlplus

9. Download tora from: http://tora.sourceforge.net/

10. unzip it and run autogen.sh

11. We need to apt-get install: (at least)

libqt3-mt-dev libqscintilla-dev perl5 make

12. configure the source with this cryptic command:

./configure --prefix=/usr/local --with-instant-client --without-rpath --disable-new-check --without-kde --with-oracle-includes=/usr/local/oracle/instantclient/sdk/include --with-oracle-libraries=/usr/local/oracle/instantclient --enable-libsuffix=

13. make; make install

14. that should do it!