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.
Oracle LazyDBA home page