Re: instant client RH EL 4.4 sqlplus

From: <kbloomfield_at_yahoo.com>
Date: Tue, 27 May 2008 06:30:41 -0700 (PDT)
Message-ID: <87285c3a-3882-4e61-967f-5a325a173e9e@59g2000hsb.googlegroups.com>


On 27 May, 14:10, yossarian <yossaria..._at_operamail.com> wrote:
> kbloomfi..._at_yahoo.com wrote:
> > Have unset ORACLE_HOME - same result.
>
> Works for me on a Slackware box.
>
> $ export LD_LIBRARY_PATH=/home/install/oracle/instantclient_10_2
> $ export ORACLE_HOME=/tmp/
> $ ./sqlplus /nolog
> 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
> $ unset ORACLE_HOME
> $ ./sqlplus /nolog
>
> SQL*Plus: Release 10.2.0.4.0 - Production on Tue May 27 15:09:31 2008
>
> Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
>
> SQL>
>

Thanks for that!
I get a slightly different result:
[user_at_server02 instantclient_10_2]$ export ORACLE_HOME=/tmp/ [user_at_server02 instantclient_10_2]$ ./sqlplus /nolog 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
[user_at_server02 instantclient_10_2]$ unset ORACLE_HOME [user_at_server02 instantclient_10_2]$ ./sqlplus /nolog 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
[user_at_server02 instantclient_10_2]$

I see that you actually have a local install of Oracle - I dont perhaps that is the difference?
BTW I did not think of ldd and /nolog to check things out - keep em coming!

Kevin

[ Received on Tue May 27 2008 - 08:30:41 CDT

Original text of this message