TOra is an open-source multi-platform database management GUI that supports accessing most of the common database platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt’s ODBC support. TOra has been built for various Linux distributions, Mac OS X, MS Windows, and UNIX platforms.
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
instantclient-basic-linux-x86-64-11.2.0.2.0.zip
instantclient-sdk-linux-x86-64-11.2.0.2.0.zip
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-11.2.0.2.0.zip
sudo unzip -d /opt/oracle/ instantclient-sdk-linux-x86-64-11.2.0.2.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
/opt/oracle/instantclient_11_2
and reload librairies.
sudo ldconfig
TOra compilation:
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
cd tora/tora
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
You’re done!
Leave a Reply