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!
Subscribe to:
Posts (Atom)