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

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

Hi,

You're welcome for the module. I'm happy to see others making as good
use of it as I already am. :-)

I am not at my Linux box at the moment but I believe you should not
need to set ORACLE_HOME at all when using the instant client. You also
need to set LD_LIBRARY_PATH to the path where the libraries are
actually found. From your description below it looks like you were
setting it to the base directory. Then again, I am using the RPM
package to install the instant client so it may be set up differently.
Rather than bother the mailing list with this, though, please send a
listing of what you have to me personally and I'll look at it tonight
if I get a chance. Also, please list all of the different versions of
Oracle that you have installed on your machine and their locations and
versions. It is most definitely possible to have both SQL*Plus and
cx_Oracle working on the same machine!

Anthony

On Wed, Sep 8, 2010 at 11:01 AM, hari jayaram <ha...@gm...> wrote:
> Hi ,
> First of thanks to Anthony and cxtools/computronix for this excellent
> module. I am using it successfully on windows, connection to a Oracle
> 10g database from 32 bit windows XP running python 2.6.
>
> However I wanted to switch my development environment to Ubuntu Lucid
> 10.04 running in 64 bit mode.
>
> After some effort I could get the cx_Oracle version 5.0.4 to install
> with the oracle 11.1 , 32 bit , i386  instantclient libraries.
> My scripts all work just fine despite the hybrid mode i.e 64 bit
> kernel, python and 32 bit instantclient libraries.
>
> My question pertains to getting oracle sqlplus to work with the same setup.
> Since its a 64 bit system I do not have Oracle 10g -Express edition
> installed on it. The only thing oracle I have is the 11_1
> instantclient.
>
> When I launch sqlplus I get the following error:
>
> harijar@ubuntuinux64bit:~/instantclient/instantclient_11_1$ ./sqlplus
> Error 6 initializing SQL*Plus
> Message file sp1<lang>.msb not found
> SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
>
>
> I do have the ORACLE_HOME and LD_LIBRARY_PATH and SQLPATH and PATH
> pointing to the instantclient/instantclient_11_1 directory.
>
>
> I know this is a cx_Oracle mailing list , but I was hoping that
> someone here knows how to solve this problem.
>
> So my question is how can I have my cake ( cx_oracle with
> instantclient 11_1) and eat it too , i.e use sqlplus that comes with
> version 11_1 on my 64 bit linux box.
> Initially on this same machine , I could get the sqlplus that came
> with instantclient 10_1 to work just fine. But I could not compile
> cx_Oracle to work with 10.1 instantclient libraries . So I switched to
> 11_1
>
> Thanks in advance
>
> Hari
>
> ------------------------------------------------------------------------------
> 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
>