In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application. Features PL/SQL debugger, SQL worksheet with syntax highlighting, DB browser and a comprehensive set of DBA tools.
This post is a little « howto » compile TOra as a debian packages with Oracle support.
Installing Oracle libraries and headers:
To get support of Oracle SGBD, we first need to get piece of software from Oracle. Though those software are not free, as in free speach, they are free, as in free beer.
Go to http://www.oracle.com/technetwork/database/features/instant-client/ and get Oracle instantclient and its SDK
Now unpack the archives in a directory that will be dedicated to Oracle:
sudo mkdir /opt/oracle
sudo unzip -d /opt/oracle/ instantclient-basic-linux-x86-64-184.108.40.206.0.zip
sudo unzip -d /opt/oracle/ instantclient-sdk-linux-x86-64-220.127.116.11.0.zip
Tell the system we added new librairies by creating the followinf file: /etc/ld.so.conf.d/oracle.conf
~$ cat /etc/ld.so.conf.d/oracle.conf
and reload librairies.
We’re gonna used the lastest sources from svn. As a consequence you must make sure you have subversion installed. If not:
sudo apt-get install subversion
Grab the sources
svn co https://tora.svn.sourceforge.net/svnroot/tora/trunk tora
and then compil compil and build package
sudo apt-get build-dep tora
ORACLE_HOME=/opt/oracle/instantclient_11_2 DEB_DH_SHLIBDEPS_ARGS_ALL='-- --ignore-missing-info' dpkg-buildpackage -b -uc
Finally we can install the packages:
sudo dpkg -i ../tora_*.deb