Re: [Sqlrelay-discussion] compiling for oracle support in ubuntu

[Joshua S. <yat...@gm...>]

Thanks everyone for your helpful replies.

Oracle's instant client "packages" don't indicate where they should
go, but by examining sqlrelay's configure script I was able to get by.
After compiling, I only copied the specific oracle connection binaries
because I had installed Ubuntu's main sqlrelay package.

The following commands got it done... prepend sudo where appropriate:

===============================
cd /tmp
unzip <PATH>/instantclient-basic*.zip
mkdir -p /usr/lib/oracle/<VERSION>/client/lib
cd /usr/lib/oracle/<VERSION>/client/lib
cp /tmp/instantclient_10_2/* .
ln -s libclntsh.so.10.1 libclntsh.so
ln -s libocci.so.10.1 libocci.so

cd /tmp
unzip <PATH>/instantclient-sdk*.zip
mkdir -p /usr/include/oracle/<VERSION>/client
cp instantclient_10_2/sdk/include/* /usr/include/oracle/<VERSION>/client

cd ~/sqlrelay-0.38
ORACLE_HOME="" ./configure --disable-python
make
cp src/connections/oracle8/.libs/sqlr* /usr/local/bin
===============================

On 7/24/07, David Muse <dav...@fi...> wrote:
> Try unsetting your ORACLE_HOME and running ./configure again.  The
> current version of SQL Relay doesn't properly detect the instantclient
> installation if ORACLE_HOME is set.  This is fixed in CVS.
>
> Make sure you installed the oracle "instantclient" package too, and not
> a different oracle package.
>
> David Muse
> dav...@fi...
>
> On Mon, 2007-07-23 at 16:42 -0700, Joshua Swink wrote:
> > I would like to use sqlrelay in Ubuntu 7.04. Unfortunately, Ubuntu
> > does not supply a package for sqlrelay and Oracle. Evidently I will
> > need to compile sqlrelay myself in order to connect with an Oracle
> > database. (The RPM is compiled against a different version of libc so
> > I cannot use that.)
> >
> > I have installed Oracle's sqlplus client, but nothing else, so
> > sqlrelay's configure script says the following:
> >
> > ***** Oracle *****************
> > checking for oracle includes and libraries... cat:
> > /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/sysliblist: No
> > such file or directory
> > no
> > configure: WARNING: Oracle support will not be built.
> > ******************************
> >
> > Where can I get the required files to compile this?