instant client RH EL 4.4 sqlplus

[kbloo...@yahoo.com]

Hello,
Am trying to configure instant client 10_2 on RH EL 4.4.
So have set LD_LIBRARY_PATH, PATH and ORACLE_HOME to the dir where the
unzipped instant client lives.
However cannot seem to connect to remote DB using sqlplus like so:
sqlplus user/password@IPAddress:1521/FRED
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

But if I invoke sqlplus user/password@FRED on the remote box this
works purfect.

I guess I am missing something, but not being an expert I am not sure
what!

Anyone care to advise?

TIA

Kevin

.

[yossarian]

kbloo...@yahoo.com wrote:

> Am trying to configure instant client 10_2 on RH EL 4.4.
> So have set LD_LIBRARY_PATH, PATH and ORACLE_HOME to the dir where the
> unzipped instant client lives.
> However cannot seem to connect to remote DB using sqlplus like so:
> sqlplus user/password@IPAddress:1521/FRED
> 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

Try to unset ORACLE_HOME

Y.

[Laurenz Albe]

Yes, you didn't tell us very much about your installation...

But let me get out my crystal ball:

Yes, I can see it clearly now: On this machine there is some other Oracle
software installed... looks very much like a server....

Question: why did you install Instant Client at all?

The image gets less clear now, but you could try the following:

- Unset ORACLE_HOME.
- Make sure that no other installed Oracle software is in PATH
and LD_LIBRARY_PATH.

Then try again!

The explanation for the error message is that your sqlplus command somehow
picks up executables from some other Oracle installation that searches
for message files in vain (there are no message files in Instant Client).

If you need better advice, give more details please, like what other
Oracle software is installed, what exactly is in the environment
variables you mention, what is the result of "ldd `which sqlplus`".

Yours,
Laurenz Albe

[yossarian]

Laurenz Albe wrote:

> The explanation for the error message is that your sqlplus command somehow
> picks up executables from some other Oracle installation that searches
> for message files in vain (there are no message files in Instant Client).

Well, I tried to install Instant Client on a Linux machine with no
Oracle software at all and I noticed it give the same message if you set
ORACLE_HOME to a valid directory. It's definitely a message that comes
from the Instant Client itself, not from another Oracle installation.

Unsetting ORACLE_HOME should be enough.

BTW, the OP was not talking about another Oracle installation on the
same machine.

Y.

[kbloo...@yahoo.com]

Hello,

Thanks for your prompt replies!

Have unset ORACLE_HOME - same result.

[user@server02 instantclient_10_2]$ ldd sqlplus
libsqlplus.so (0x0069d000)
libclntsh.so.10.1 (0x00751000)
libnnz10.so (0x00154000)
libdl.so.2 => /lib/libdl.so.2 (0x00111000)
libm.so.6 => /lib/tls/libm.so.6 (0x00115000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0x004ca000)
libnsl.so.1 => /lib/libnsl.so.1 (0x0035a000)
libc.so.6 => /lib/tls/libc.so.6 (0x00370000)
/lib/ld-linux.so.2 (0x0013d000)

Actually there is no other Oracle software on the box. The intention
is to spin up an Oracle gateway on this box which will pull data off
another box and squirt it into clustered Oracle also on a dfferent
box.

This gateway requires the installation of the Oracle Instant Client -
although the gateway does not need the sqlplus add-on to instant
client, I am pretty sure an sqlplus prompt is going to be helpful!

[user@server02 instantclient_10_2]$ ls
BASIC_README classes12.jar glogin.sql libnnz10.so
libociei.so libsqlplus.so ojdbc14.jar
SQLPLUS_README genezi libclntsh.so.10.1 libocci.so.10.1
libocijdbc10.so libsqlplusic.so sqlplus

Kevin

On 27 May, 12:59, Laurenz Albe <inv...@spam.to.invalid> wrote:

> Laurenz Albe- Hide quoted text -
>
> - Show quoted text -

[yossarian]

kbloo...@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>

Y.

[kbloo...@yahoo.com]

On 27 May, 14:10, yossarian <yossaria...@operamail.com> wrote:

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

[

[joel garry]

I'm wondering if your ipaddress is properly specified - put in two
slashes after the @ sign?

Also, can you connect with the oracle style connection string like in
your tnsnames.ora:
sqlplus user/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=ipaddress) (PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=FRED)))

In the past I recall that I had trouble, then tried it again following
the directions exactly, including putting the tnsnames.ora in the
instant client directory, and it suddenly all worked. But that was a
different version and platform.

jg
--
@home.com is bogus.
Welcome to California. Now go back to Chicago.
http://www.signonsandiego.com/news/business/20080527-9999-1b27mega.html
word: cainitte

[Laurenz Albe]

kbloo...@yahoo.com wrote:
>> Works for me on a Slackware box.
>>

[...]

>>
>> $ 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@server02 instantclient_10_2]$ export ORACLE_HOME=/tmp/
> [user@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@server02 instantclient_10_2]$ unset ORACLE_HOME
> [user@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@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!

Sorry for my bad guess earlier - looks like I got to polish my crystal ball
more frequently ...

As a last resort you can use 'strace' to find out what files are accessed.
You could try:

echo | strace -e trace=open,access -f -o trace.log ./sqlplus /nolog

and examine trace.log to see what files are opened, and where it fails.

On my system, the Oracle files accessed are (in that order):
libsqlplus.so
libclntsh.so.10.1
libnnz10.so
libsqlplusic.so
libociei.so

Then it tries to read login.sql and glogin.sql.

Yours,
Laurenz Albe