Re: Access to Oracle db from ROOT

From: Fons Rademakers <Fons.Rademakers_at_cern.ch>
Date: Wed, 09 Mar 2005 11:49:52 +0100


Hi Marina,

   the Oracle module is not build by default. You need to follow the steps described at the GSI website to build this module.

If you can switch to the ROOT cvs head then you can use the new, recently introduced, Orcale interface (works the same at the other SQL interfaces). To use it you only need to install the oracle instantclient rpms:

oracle-instantclient-basic-10.1.0.3-1.i386.rpm oracle-instantclient-devel-10.1.0.3-1.i386.rpm

Cheers, Fons.

Marina Giunta wrote:
> Hello,
> I'm trying to access an Oracle db using the TSQLServer class, but when
> I give this command
>
> TSQLServer* myDb =
> TSQLServer::Connect("oracle://devdb10.cern.ch","user","passwd");
>
> I get this error message:
>
> Error in <TUnixSystem::DynamicPathName>: Oracle[.so | .sl | .dl | .a]
> does not exist in .:/afs/cern.ch/cms/external/gcc-3.2/ROOT/3.05.07a//lib:
> /afs/cern.ch/project/oracle/@sys/10103/lib:/usr/local/gcc-alt-3.2.3/lib/
> : /afs/cern.ch/cms/external/gcc-3.2/ROOT/3.05.07a//lib
>
> I had a look at the documentation in:
>
> http://www-w2k.gsi.de/root/Oracle/Install.htm
>
> but I couldn't find a solution: I set $ORACLE_HOME to the CERN Oracle
> directory in afs (Oracle version 10.1.03), but I need to create the
> shared library libOracle.so for my version of Oracle.
>
> How can I solve this problem?
>
> Thanks.
> Marina
>
> --
> Marina Giunta
> -----------------------------------------------
> Department of Physics, | At CERN
> UC Riverside, | OFF: 28-2-006
> Riverside CA92521 USA | TEL: +41-22-76-78178
> -----------------------------------------------

-- 
Org:    CERN, European Laboratory for Particle Physics.
Mail:   1211 Geneve 23, Switzerland
E-Mail: Fons.Rademakers_at_cern.ch              Phone: +41 22 7679248
WWW:    http://www.rademakers.org/fons/      Fax:   +41 22 7679480
Received on Wed Mar 09 2005 - 11:49:55 MET

This archive was generated by hypermail 2.2.0 : Tue Jan 02 2007 - 14:45:05 MET