Tora with Oracle

Tora with Oracle on debian(Ubuntu)

Oracle on debian

Added this server is in your apt sources list.

# sudo vi /etc/apt/source.list
deb http://oss.oracle.com/debian unstable main non-free

# wget http://oss.oracle.com/el4/RPM-GPG-KEY-oracle -O- | sudo apt-key add -

# sudo apt-get install oracle-xe-client oracle-xe-universal
# sudo /etc/init.d/oracle-xe configure

export LD_LIBRARY_PATH=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib:$LD_LIBRARY_PATH
export TNS_ADMIN=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/admin/
export PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server

Please check/add the oracle_xe.conf in /etc/ld.so.conf.d/ directory.
Content of oracle_xe.conf is :
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib

and check the access the console via: http://127.0.0.1:8080/apex

To install tora:

Install several packages needed for rebuilding:
# sudo apt-get install g++ gcc autoconf automake flex zlib1g-dev docbook-xsl
# sudo apt-get install libqt3-mt-dev libqt3-compat-headers
# sudo apt-get xlibs-dev libqt3-headers kde-devel

You can also get the debian source with
sudo apt-get source tora or directly from sourceforge:
# wget http://mesh.dl.sourceforge.net/sourceforge/tora/tora-1.3.22.tar.gz
# tar xzf tora-1.3.18.tar.gz
# cd tora-1.3.18/

./configure --prefix=/usr --with-oracle=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server --without-rpath --disable-new-check --without-kde --enable-libsuffix=

then:
# make
# make install

or do change the configuration file :
change the line containing “./configure” in the debian/rules file to the:
./configure –prefix=/usr –with-oracle=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server –without-rpath –disable-new-check –without-kde –enable-libsuffix=

# sudo dpkg-buildpackage.
# sudo dpkg -i ../tora_*.deb

You can also using the SQL Developer from Oracle:
http://www.oracle.com/technology/software/products/sql/index.html