Oracle support

ROOT
3

[quote=“linev”]Hi, Mariusz
ROOT sources includes full-functional implementation of TSQLServer class. It is not compiled by default - in most cases you should install InstantClient from Oracle first and than configure and compile ROOT appropriately. See some tips in documentation for TOracleServer class:
http://root.cern.ch/root/html/TOracleServer.html

Regards,
Sergey

P.S. Most probably, in CERN it is compiled per defualt (check in $ROOTSYS/lib/libOracle.so). If it is there, just try

sql = TSQLServer::Connect("oracle://server/db-name","user","pass");

Of course, correct server, db-name, user and pass should be specified.[/quote]

Thanks Sergey,

I have compiled root 5.16 with:
./configure --enable-oracle --with-oracle-libdir=/usr/lib/oracleClient --with-oracle-incdir=/usr/include/oracle/11.1.0.1/client/

now when I do ldd /cern/root/lib/libOracle.so
I get:
linux-gate.so.1 => (0x00110000)
libclntsh.so.11.1 => /usr/lib/oracleClient/libclntsh.so.11.1 (0x00670000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x00139000)
libm.so.6 => /lib/libm.so.6 (0x00224000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x0024d000)
libc.so.6 => /lib/libc.so.6 (0x00259000)
libnnz11.so => /usr/lib/oracleClient/libnnz11.so (0x003b2000)
libdl.so.2 => /lib/libdl.so.2 (0x0055c000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00561000)
libnsl.so.1 => /lib/libnsl.so.1 (0x0057a000)
libaio.so.1 => /usr/lib/libaio.so.1 (0x00593000)
/lib/ld-linux.so.2 (0x00653000)

there is no link to libocci.so, which is strange, isn’t it?
When I do:
TSQLServer* sql = TSQLServer::Connect(MTFServer,MTFUser,MTFPasswd);

I get:
dlopen error: /cern/root/lib/libOracle.so: undefined symbol: _ZTIN6oracle4occi12SQLExceptionE

what to do with it?

Mariusz