Answer : It's an Oracle 10.2.0.x bug. Permissions are screwed up. Get a
patch from oracle.


"Nkansah Derek " <oracledba-ezmlmshield-x1827448.[Email address protected]
wrote on 09/05/2006 11:34:49 AM:

> 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
>
>


--
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.

Oracle LazyDBA home page