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

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

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"

That directory has
~/instantclient/instantclient_11_1$ ls -1
adrci
BASIC_README
genezi
glogin.sql
libclntsh.so.11.1
libnnz11.so
libocci.so.11.1
libociei.so
libocijdbc11.so
libsqlplusic.so
libsqlplus.so
ojdbc5.jar
ojdbc6.jar
sdk
sqlplus
SQLPLUS_README


To compile and install cx_office . I had also symlinked
libclntsh.so.11.1 to  libclntsh.so in the same directory and set the
ORACLE_HOME

I could then sudo setup.py build and , sudo -E setup.py install the
cx_oracle module.

The module works just fine


ON This setup :
:~/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


It is quite weird. Sometimes it gives the above error and other times
it Segmentation faults
I unset ORACLE_HOME and removed the symlink from  libclntsh.so.11.1 to
 libclntsh.so and I get the same behavior, segfaults or Error 6 with
SP2-0750.

On the same setup with all the environment variables setup to point to
11_1, I can still run the 10_1 version of sql*plus

So this is indeed strange behavior.

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.

Thanks again..and hoping there is a quick fix

Hari

On Wed, Sep 8, 2010 at 4:21 PM, Robert <web...@gm...> wrote:
> This has nothing to do with cx_oracle.
> but if I were you I would also have echo'd those env variables and
> show to the people you're asking for help.
>
>
> On Wed, Sep 8, 2010 at 1:01 PM, hari jayaram <ha...@gm...> wrote:
>> 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
>>
>
> ------------------------------------------------------------------------------
> 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
>