How to build Tora 2.1 with Oracle support

How to build Tora 2.1 with Oracle support

In ubuntu 8.10, "tora" package version is 1.3.23 and not support Oracle, If you want to use the new version use must download TORA souce code from "http://torasql.com" and then if you want to use TORA connect to Oracle use must download Oracle Instantclient or Oracle Client from Oracle Website.

Download Oracle Instantclient 11 from Oracle's webstie
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/linuxsoft.html
There are 2 packages that you need

- Instant Client Package - Basic
- Instant Client Package - SDK
- Instant Client Package - SQL Plus ( Optional for test connection only )

Then when you have everything already, let go to next step
unzip Instant Client Package - Basic
# unzip instantclient-basic-linux32-11.2.0.1.zip
unzip Instant Client Package - SDK
# unzip instantclient-sdk-linux32-11.2.0.1.zip
unzip Instant Client Package - SQL Plus
# unzip instantclient-sqlplus-linux32-11.2.0.1.zip

Create soft link for Oracle Instantclient library:
#cd /home/tatshuya/instantclient_11_2
#ln -s libclntsh.so.11.1 libclntsh.so

Before you compile you need some library
#apt-get install libqt4-dev libqscintilla2-dev build-essential

Prepare Variable environment before compile the tora
#export LD_LIBRARY_PATH=/home/tatshuya/instantclient_11_2
#export CPPFLAGS="-I/home/tatshuya/instantclient_11_2/sdk/include"

Compile TORA
#cd ../tora-2.1.0
#./configure --with-instant-client=/home/tatshuya/instantclient_11_2
#make
#make install

Then use tora program
#export LD_LIBRARY_PATH=/home/tatshuya/instantclient_11_2
#/usr/local/tora/bin/tora