This content has been marked as final.
Show 15 replies
-
1. Re: sqlplus with Instant Client?
Pavan Kumar Dec 29, 2009 6:22 PM (in response to rmmangin)Hi,
Might be the SQL Client files got corrupted or download Installation is corrupted. Try to re-install and Check.
Is this 11g which you are working on.
I am not sure still.
- Pavan Kumar N
Oracle 9i/10g - OCP
http://oracleinternals.blogspot.com/ -
2. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 6:35 PM (in response to rmmangin)rmmangin wrote:
Did you set LD_LIBRARY_PATH ? What was the sequence of unzip ?
instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip -
3. Re: sqlplus with Instant Client?
rmmangin Dec 29, 2009 6:55 PM (in response to Pavan Kumar)$ORACLE_HOME is set to the base directory under which the lib and bin directories are located (/opt/oracle/product/ora_current).
$LD_LIBRARY_PATH includes both $ORACLE_HOME/lib and $ORACLE_HOME/bin.
The instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip files were both unzipped (in that order) into the $ORACLE_HOME/lib direcotry.
The instantclient-sqlplus-linux32-11.2.0.1.zip was unzipped last, into the $ORACLE_HOME/bin directory.
When I try "fine $ORACLE_HOME sp1us.msb -print" there is no sp1us.msb found. In fact there are no *.msb files anywhere under $ORACLE_HOME.
Should sp1us.msb have been part of the instantclient-sqlplus-linux32-11.2.0.1.zip file?
The database to which I want to connect is 10g. The 11g Instant Client should connect ok, right?
Thanks all. -
4. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 7:17 PM (in response to rmmangin)Can you please post the output of
env | sort
Is NLS_LANG set ?
Is TNS_ADMIN set ? -
5. Re: sqlplus with Instant Client?
rmmangin Dec 29, 2009 7:59 PM (in response to 367117)Neither NLS_LANG nor TNS_ADMIN is set.
There are quite a few environment variables set. I've omitted a few to keep this post to a reasonable size ;-)
With that said, here is the output from env | sort
DISPLAY=:0
EDITOR=vi
ENV=/home/roger/.kshrc
GTK_RC_FILES=/etc/gtk/gtkrc:/home/roger/.gtkrc-1.2-gnome2
HISTSIZE=800
HOME=/home/roger
JAVA_HOME=/usr/java/jre1.6.0_15
JRE=/usr/java/jre1.6.0_15
LANG=en_US.UTF-8
LD_LIBRARY_PATH=/lib:/opt/oracle/product/ora_current/lib:/opt/oracle/product/ora_current/bin:/usr/lib/netscape/plugins
LOGNAME=roger
MM_CHARSET=iso-8859-1
MOZ_ENABLE_PANGO=1
NPX_PLUGIN_PATH=/usr/lib/netscape/plugins
ORACLE_HOME=/opt/oracle/product/ora_current
OS=Linux
PATH=/usr/bin:/bin:/usr/X11R6/bin:/home/roger/bin:/usr/java/jre1.6.0_15/bin:/opt/oracle/product/ora_current/bin:/opt/bin:.:/usr/local/bin
PRINTER=nlj
PS1=$HOSTNM:$PWD>
TERM=xterm-color -
6. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 8:25 PM (in response to rmmangin)rmmangin wrote:
set
Neither NLS_LANG nor TNS_ADMIN is set.
LD_LIBRARY_PATH=/lib:/opt/oracle/product/ora_current/lib:/opt/oracle/product/ora_current/bin:/usr/lib/netscape/plugins
ORACLE_HOME=/opt/oracle/product/ora_current
PATH=/usr/bin:/bin:/usr/X11R6/bin:/home/roger/bin:/usr/java/jre1.6.0_15/bin:/opt/oracle/product/ora_current/bin:/opt/bin:.:/usr/local/bin
$ export LD_LIBRARY_PATH=$ORACLE_HOME/bin:$LD_LIBRARY_PATH
$ export PATH=$ORACLE_HOME/bin:$PATH
and then post the results of
$ sqlplus
Will you be using TNS_ADMIN (For TNSNames) ? If so, set TNS_ADMIN
Do you have multiple ORACLE Homes on this machine ? -
7. Re: sqlplus with Instant Client?
rmmangin Dec 29, 2009 9:08 PM (in response to 367117)Thanks for the concrete suggestion. I ran the two export commands; sqlplus still reports
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Note that $ORACLE_HOME/bin was already in LD_LIBRARY_PATH. Was your suggestion specifically to make it the first directory there (i.e., that there is importance to the order in which directories appear in LD_LIBRARY_PATH)?
The box on which I'm trying to get this installed is a desktop Linux box. It has no Oracle db installed on it. I'm trying to use it only as a client to access an Oracle 10g database on a Sun Solaris box. There is only one $ORACLE_HOME on the Linux desktop box (/opt/oracle/product/ora_current). Note that "ora_current" is a symbolic link to "11.2" which is the real directory under which the lib and bin directories are located.
I do not plan to use TNS_ADMIN.
I am still perplexed -- if sqlplus needs sp1<lang>.msb, why is that file not part of the instantclient-sqlplus-linux32-11.2.0.1.zip file?
There are NO .msb files anywhere under the $ORACLE_HOME directory. Should I be trying to find a file "sp1us.msb" somewhere on OTN?
Thanks again. -
8. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 9:26 PM (in response to rmmangin)rmmangin wrote:
Seems like permission issue to me.
Thanks for the concrete suggestion. I ran the two export commands; sqlplus still reports
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Are you executing SQLPLUS from Oracle user ?
There is only one $ORACLE_HOME on the Linux desktop box (/opt/oracle/product/ora_current). Note that "ora_current" is a symbolic link >to "11.2" which is the real directory under which the lib and bin directories are located.
Try to execute these and see what you get...
ls -alt $ORACLE_HOME/bin
ls -alt $ORACLE_HOME/lib
Was your suggestion specifically to make it the first directory there
Yes, my intent was to bring ORACLE_HOME directory in the PATH and LD_LIBRARY_PATH as the first entry. -
9. Re: sqlplus with Instant Client?
ioan Dec 29, 2009 9:53 PM (in response to rmmangin)Hi,1 person found this helpful
Here is a link with info how to configure an instant sqlplus client for linux.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ape.htm#CHDJCDFA
Hope this help.
Ioan -
10. Re: sqlplus with Instant Client?
EdStevens Dec 29, 2009 9:56 PM (in response to rmmangin)rmmangin wrote:
I've never tried to install instant client on a *nix platform, but going to the download page I see this:
Other than instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip what other modules must be installed to use sqlplus with Instant Client to connect to database on a remote server? When I run sqlplus it errors out with "SP2-0667: Message file sp1<lang>.msb not found". The instantclient-sqlplus package does not have any *.msb files in it.
Instant Client Package - SQLPlus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-11.2.0.1.zip (795,144 bytes) (cksum - 1471854444)
You didn't mention having that file .... -
11. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 9:56 PM (in response to 367117)Or you can review this link...
http://download.oracle.com/docs/cd/E11882_01/server.112/e10823/apd.htm#CHDJCDFA -
12. Re: sqlplus with Instant Client?
367117 Dec 29, 2009 10:05 PM (in response to EdStevens)EdStevens wrote:
rmmangin wrote:
Other than instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zipI've never tried to install instant client on a *nix platform, but going to the download page I see this:
Isn't that the first file in the list ?
Instant Client Package - SQLPlus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-11.2.0.1.zip (795,144 bytes) (cksum - 1471854444)
You didn't mention having that file .... -
13. Re: sqlplus with Instant Client?
rmmangin Dec 29, 2009 10:30 PM (in response to ioan)Thanks everyone for the suggestions. As is so often the case, this was just "user error" on my part ;-}
I was stubbornly determined to put everything from instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zip into a lib directory under $ORACLE_HOME, and put everything from instantclient-sqlplus-linux32-11.2.0.1.zip into a bin directory under $ORACLE_HOME.
All I had to do was unzip all 3 files into the same directory, and make that be $ORACLE_HOME. Voila, sqlplus now runs on this desktop linux box, and can connect to the various 10g databases on Solaris boxes.
Again, thanks all. -
14. Re: sqlplus with Instant Client?
EdStevens Dec 30, 2009 1:48 AM (in response to 367117)ordba wrote:
Ooops. My bad.EdStevens wrote:
rmmangin wrote:
Other than instantclient-sqlplus-linux32-11.2.0.1.zip and instantclient-basic-linux32-11.2.0.1.zip and instantclient-sdk-linux32-11.2.0.1.zipI've never tried to install instant client on a *nix platform, but going to the download page I see this:
Isn't that the first file in the list ?
Instant Client Package - SQLPlus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-linux32-11.2.0.1.zip (795,144 bytes) (cksum - 1471854444)
You didn't mention having that file ....