Re: instant client RH EL 4.4 sqlplus

kbloomfield_at_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_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!

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 Received on Wed May 28 2008 - 02:58:22 CDT