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

[hari j. <ha...@gm...>]

Thanks Everyone ,

I followed the instructions on stackoverflow posted by Mark Harrison.
The instructions called for putting everything manually into
/usr/include ( all the *.h files ) /usr/lib ( the *.so files ) and
/etc ( the tnsanames.ora).

ANd this then gets the instantclient version 11_1 working.

This brute force approach did get things working..It may be that the
sqlplus binary was not getting the libraries from my LD_LIBARRY_PATH
because putting the *.so containing directory at the start still gave
me the same error.


Thanks for your help
Hari


On Wed, Sep 8, 2010 at 11:19 PM, Anthony Tuininga
<ant...@gm...> wrote:
> 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
>
> ------------------------------------------------------------------------------
> This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>