I thought it was environmental at first too but it's not.
I had the same problem in HP/UX.
This is a bug in 10.2.
You need to apply a one-off patch (# 4516865).
~Ruth
-----Original Message-----
From: Nkansah Derek
[mailto:oracledba-ezmlmshield-x1827448.[Email address protected]
Sent: Tuesday, September 05, 2006 11:35 AM
To: LazyDBA Discussion
Subject: RE: Error 6 initializing SQL*Plus
It is your environment, my man. The user doesn't have the ORACLE
environment set up. This is got to be the most easiest. What are the
differences between my user and the oracle user?? Answer: Environment
Variables !.
-----Original Message-----
From: Krupetsky Milana
[mailto:oracledba-ezmlmshield-x22954872.[Email address protected]
Sent: 24 August 2006 22:14
To: LazyDBA Discussion
Subject: RE: Error 6 initializing SQL*Plus
Somebody, Please help!
Just installed another ORACLE_HOME(10.2.0.1) on the SUN server. When
logged in as Oracle, everything is fine, but when logged in as other
users and try to invoke sqlplus I get
gsperf2:/export/home/perflab > sqlplus
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
gsperf2:/export/home/perflab >
ORACLE_HOME is set
ORACLE_LIB is set
PATH is set
gsperf2:/export/home/perflab > echo $ORACLE_HOME
/opt/oracle/product/10.2.0.1
gsperf2:/export/home/perflab > echo $PATH
/opt/oracle/product/10.2.0.1/bin:/export/home/perflab/bin:/bin:/bin::/bi
n:/run_env/SunOS.5.8_ora9.2.0.6/FES731_qa/ServiceManager:/export/home/pe
rflab/real/SunOS.5.8_ora9.2.0.6/FES731_qa/bin:/export/home/perflab/real/
SunOS.5.8_ora9.2.0.6/FES731_qa/BaseComponents/bin/:/opt/SUNWspro/WS6U1/b
in:/opt/merant/mf42/bin:/usr/java/bin:/usr/bin:/usr/sbin:/usr/ucb:.:/usr
/bin:/run_env/SunOS.5.8_ora9.2.0.6/FES731_support/bin:/bin:/etc:/usr/etc
:/opt/bin:/usr/ccs/bin:/opt/oracle/product/10.2.0.1/bin:/run_env/SunOS.5
.8_ora9.2.0.6/FES731_support/bin:/opt/merant/mf42/bin:.:/usr/atria/bin:/
export/home/perflab/bin:/opt/mqm/bin/bin:/usr/atria/bin:/export/home/per
flab/bin:/usr/local/bin
ORACLE_HOME/bin permissions are set.
Please keep in mind that it is 10G. Any suggestions would be greatly
appreciated
Thanks,
Milana
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
This e-mail (and any attachments) contains information, which is
confidential and intended solely for the attention and use of the named
addressee(s). If you are not the intended recipient you must not copy,
distribute or use it for any purpose or disclose the contents to any
person. If you have received this e-mail in error, please notify us
immediately at [Email address protected] The information contained in
this e-mail (and any attachments) is supplied in good faith, but the
sender shall not be under any liability in damages or otherwise for any
reliance that may be placed upon it by the recipient. Any comments or
opinions expressed are those of the originator not of NTT Europe Ltd
unless otherwise expressly stated.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page