<> ||<>|| = Installing Tora with Oracle Support = The "tora" database client package in FeistyFawn comes with Postgres support, and MySQL if you have the libraries. This How-To shows you how to build Oracle Instantclient 10g support into tora. This is client only. You will not install the whole Oracle database. '''NOTE''': Packages for more recent Ubuntu versions may be found on [[https://launchpad.net/tora-oracle|Launchpad]], please also note that ''/etc/ld.so.conf.d/oracle.conf'' must be created instead of setting LD_LIBRARY_PATH since Ubuntu 9.04 (see [[https://help.ubuntu.com/community/EnvironmentVariables|Help]]). == First Step: Install Oracle Instantclient == The instructions for this stage are on the page [[Oracle Instant Client]]. The Oracle Client SDK is needed to build Tora. When sqlplus is working correctly, move on to compiling "tora" == Second Step: Build Tora == * Install some required libraries: {{{ apt-get install build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev apt-get install debhelper dpatch texinfo }}} On [[LucidLynx]], building tora-2.1.1, the following packages are also needed: {{{ apt-get install cdbs cmake apt-get install qt-qmake libqt4-dev apt-get install libqscintilla2-dev }}} In order to retain [[PostgreSQL]] and [[MySQL]] support, development packages for those are also required: {{{ apt-get install postgresql-dev libmysqlclient-dev }}} * Download the tora source code: {{{ sudo apt-get source tora }}} * Edit some build lines for Instantclient (not required for tora-2.1.1 on [[LucidLynx]]): {{{ cd /usr/src/tora-1.3.21 sudo vi debian/rules }}} change the line: {{{ ./configure --prefix=/usr --without-oracle --without-rpath --disable-new-check --with-kde --enable-libsuffix= }}} to look like this: {{{ ./configure --prefix=/usr --with-instantclient --with-oracle-includes=/usr/include/oracle/11.1.0.1/client --without-kde --without-rpath --disable-new-check --enable-libsuffix= }}} * Now you're ready to build. First become root: {{{ sudo -i }}} * If ORACLE_HOME is not already set, point it to the appropriate place: {{{ export ORACLE_HOME=/usr/lib/oracle/11.1.0.1/client }}} * Then build: {{{ cd /usr/src/tora-1.3.21 debian/rules binary }}} If all goes well, after a "'long'" time, you should end up with a file in {{{/usr/src}}} called "tora_1.3.21-3ubuntu1_i386.deb". You can install it like this: {{{ dpkg -i tora_1.3.21-3ubuntu1_i386.deb }}} If dpkg gives an error like so: {{{ tora depends on libqt3-mt-psql | libqt3-mt-odbc | libqt3-mt-mysql; however: Package libqt3-mt-psql is not installed. Package libqt3-mt-odbc is not installed. Package libqt3-mt-mysql is not installed. }}} you can have apt fix its dependencies like so (afterwhich running the above dpkg -i command again should work): {{{ apt-get -f install }}} == Step Three: Using Tora to connect to an Oracle database == * Start "tora". * In the connect box make sure the connection provide says "Oracle. Then enter an Instantclient connect string in the boxes. Put "username" and "password" in the appropriate places. Then put the string {{{//dbhost:/SID}}} in the "Database" box. [[attachment:tora-connect.png|Here]] is a picture. ---- This How-To owes thanks to [[http://www.benpinter.net/article.php?story=20051208034638928|this]] page from Ben Pinter; [[https://help.ubuntu.com/community/tOraOracleSetUpHowTo|this]] page, which was a bit outdated; and [[http://ubuntuforums.org/showthread.php?t=92528|this]] entry on Ubuntuforums. ---- CategorySoftware