This article will explain how to compile Toad with Oracle 10g XE on Debian Linux. With limited changes you will be able to sort out the same installation on any Oracle release along with various Linux distributions like Ubuntu, CentOS, Redhat, Fedora, Mandrake etc.
First of all install a 32bit Debian and not 64bit as on the last Oracle wont play enough. You can get the latest Oracle binaries direct from oracle or from our repository at http://status-guru-host.com/downloads/.
Most important to install the depedencies. The whole secret is here. Adjust the binaries according to your system. Example apt-get should be like:
apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl debhelper alien libaio1 dpatch fakeroot xsltproc texi2html texinfo libqt3-mt-psql libqt3-mt-odbc config-package-dev cmake qt4-dev-tools libqscintilla2-dev
As soon as you install the above packages issue the following:
apt-get source tora
and then cd tora-version…..
In the next step we need to configure the source with Oracle installed. The following command assume that you have Oracle 10g XE Universal installed on either Debian lenny or testing.
1. export LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/
2. ./configure –prefix=/usr –with-instantclient –with-oracle-includes=/usr/lib/oracle/xe/app/oracle/product. /10.2.0/client/lib –without-kde –without-rpath –disable-new-check –enable-libsuffix=
4. make install
That’s all, run toad and you’ll see the Oracle been available. If you have any queries please post a comment here. Enjoy!