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

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

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