Re: instant client RH EL 4.4 sqlplus

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 27 May 2008 11:59:55 GMT
Message-ID: <1211889592.741620@proxy.dienste.wien.at>


kbloomfield_at_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_at_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_at_FRED on the remote box this
> works purfect.
>
> I guess I am missing something, but not being an expert I am not sure
> what!

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 Received on Tue May 27 2008 - 06:59:55 CDT

Original text of this message