Re: [cx-oracle-users] newbie question : sqlplus not working but can get cx_oracle to send sql queries

[Anthony T. <ant...@gm...>]

On Wed, Sep 8, 2010 at 2:40 PM, hari jayaram <ha...@gm...> wrote:
> I didnt send the follow up email to the list ..but here is the setup.
>
> I have the following set to the directory that has the *.so files
>
> export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/hari/instantclient/instantclient_11_1"
> export PATH="$PATH:/home/hari/instantclient/instantclient_11_1"
> export SQLPATH="/home/hari/instantclient/instantclient_11_1"
> export ORACLE_HOME="/home/hari/instantclient/instantclient_11_1"

I am using the instant client RPM so it lays things out a little
differently. Specifically, I have folders like this

/usr/lib/oracle/11.2/client/bin
/usr/lib/oracle/11.2/client/lib

It also adds the file

/etc/ld/so.conf.d/oracle-instantclient11.2.conf

which sets the library loader path automatically. What that tells me,
though, is that you should NOT set ORACLE_HOME. Its also possible that
you have another installation of Oracle somewhere in the PATH or
LD_LIBRARY_PATH that is conflicting. Make sure the one you want is
FIRST in the path -- from the above you are setting them as the LAST
item which means anything already set there is going to cause
problems. Take a look at those values and see what is in there
already.

> I was wondering if it is trivial to compile cx_oracle to run with the
> 10_1 client libraries, so I can have a homogenoeous system.

It should not be a problem. What problem are you seeing?

> Thanks again..and hoping there is a quick fix

I think so. Just look more carefully at your environment variables. :-)

Anthony