"Jangan meminta kepada Allah supaya engkau dipindah dari suatu keadaan (hal) ke keadaan yang lain. Sekiranya Dia menghendaki yang demikian, Dia tentu telah memindahkanmu tanpa mengubah keadaanmu sebelumnya."

Rebuilding TORA to support Oracle in Debian Squeeze

  • strict warning: Non-static method view::load() should not be called statically in /etc/drupal/6/sites/www.bekatul.info/modules/views/views.module on line 903.
  • strict warning: Declaration of views_handler_field::query() should be compatible with views_handler::query($group_by = false) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_handler_sort::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_handler_sort::options_submit() should be compatible with views_handler::options_submit($form, &$form_state) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_handler_sort::query() should be compatible with views_handler::query($group_by = false) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_handler_filter::options_validate() should be compatible with views_handler::options_validate($form, &$form_state) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_handler_filter::query() should be compatible with views_handler::query($group_by = false) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_plugin_query::init() should be compatible with views_plugin::init(&$view, &$display) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_plugin_style_default::options() should be compatible with views_object::options() in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Declaration of views_plugin_row::options_validate() should be compatible with views_plugin::options_validate(&$form, &$form_state) in /etc/drupal/6/sites/www.bekatul.info/modules/views/includes/handlers.inc on line 90.
  • strict warning: Only variables should be passed by reference in /etc/drupal/6/sites/www.bekatul.info/modules/shoutbox/shoutbox.module on line 420.
  • strict warning: Only variables should be passed by reference in /etc/drupal/6/sites/www.bekatul.info/modules/shoutbox/shoutbox.module on line 194.
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

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

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