Al-Hikam: Hikmah 39

"Jangan memohon kepada selain Allah karena Dialah yang memenuhi hajatmu. Bagaimana sesuatu selain-Nya bisa mengubah sesuatu yang sudah ditetapkan-Nya? Dan bagaimana orang yang tak mampu membebaskan dirinya dari kebutuhan dapatmembebaskan kebutuhan orang lain?"

Rebuilding TORA to support Oracle in Debian Squeeze

Submitted by danang.wijanarko on Thu, 07/09/2009 - 19:19 ◊
by danang.wijanarko@gmail.com


Who you are supposed to be ?

You are a geek ...

You are an integrator or architect ...

You are lost in *nix OS, and forgot how to use m$ windows ...

You are in forced to deal with Big Head Oracle ...

You are jealous that people in m$ windows world easily diggin' to Oracle database using TOAD ...

and you are a handsome guy that using bloody Debian Squeeze !!!

So if you are all of that, lets continue.

Prerequisites

Install the oracle instance client on your Squeeze, take a look on my article "Oracle Instance Client @ Debian Squeeze"

# apt-get install cmake cdbs qt4-qmake libqt4-dev libqscintilla2-dev
# cd /tmp
# apt-get source tora

Build and Install

Get the oracle include path and oracle home path of oracle-instantclient11.1-devel and oracle-instantclient11.1-basiclite

# dpkg -L oracle-instantclient11.1-devel
...
/usr/include/oracle/11.1/client
...
# dpkg -L oracle-instantclient11.1-basiclite
...
/usr/lib/oracle/11.1/client
...

Edit flags to compile with oracle support

# vi /usr/share/cdbs/1/class/cmake.mk
...
DEB_CMAKE_NORMAL_ARGS = ... -DORACLE_INCLUDES="/usr/include/oracle/11.1/client" -DORACLE_HOME="/usr/lib/oracle/11.1/client"
...

Build the debian package

# cd tora-2.0.0/
# ./debian/rules binary
...
dpkg-deb: building package `tora' in `../tora_2.0.0-4_i386.deb'.
...

Install the debian tora package

# dpkg -i tora_2.0.0-4_i386.deb

Test

Run the tora and add the connection like this:

Hope that's help !

 

 - d

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

To comply with wheezy

Submitted by danang.wijanarko on Wed, 03/23/2011 - 23:46.

Needed version :

  • Instant Client Package – Basic or Basic Lite (This is the client that will handle the connections to the server. The difference between the versions is that the Basic Lite one is only in English and its filesize is smaller);
  • Instant Client Package – SQL*Plus (Excellent for testing the installation and running PL/SQL scripts from the CLI);
  • Instant Client Package – SDK (Needed for compiling TOra).

FIles:

  • oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
  • oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm
  • oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm

Then get, build , and use tora:

  1. Revert the with alien, install, and make sure the LD_LIBRARY_PATH is on the way.
  2. After get the source just do apt-get build-dep tora
  3. add "-DORACLE_PATH_INCLUDES=/usr/include/oracle/11.2/client64 -DORACLE_PATH_LIB=/usr/lib/oracle/11.2/client64/lib" in the /usr/share/cdbs/1/class/cmake.mk.
  4. then do dpkg-buildpackage -tc -us -uc in tora source

Configuration TORA with Oracle

Submitted by Anonymous (not verified) on Thu, 11/11/2010 - 22:57.

Hi,

I have not the same version, install the 2.1.2-1.
This part of the configuration fails me, I need to use tora could help with postgres on debian linux and Squeeze

"Bekatul Port" Personal Enterprise Number (PEN) registered @ IANA OID

ASN.1 Notation: {iso(1) identified-organization(3) dod(6) internet(1) private(4) enterprise(1) 30347}

Dot Notation: 1.3.6.1.4.1.1.30347

IRI Notation: oid:/ISO/Identified-Organization/6/1/4/1/30347


View Stat Counter