Re: instant client RH EL 4.4 sqlplus
Date: Tue, 27 May 2008 06:00:48 -0700 (PDT)
Message-ID: <df04f55b-efc4-4166-a330-d90a6e87a781@x41g2000hsb.googlegroups.com>
Hello,
Thanks for your prompt replies!
Have unset ORACLE_HOME - same result.
[user_at_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_at_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.1libocijdbc10.so libsqlplusic.so sqlplus
Kevin
On 27 May, 12:59, Laurenz Albe <inv..._at_spam.to.invalid> wrote:
> kbloomfi..._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- Hide quoted text -
>
> - Show quoted text -
Received on Tue May 27 2008 - 08:00:48 CDT