Re: Can't login SqlPlus

By default, 10g has the local oracle install locked down to only be used by owner:group (typically oracle:dba). You need to run $ORACLE_HOME/install/changePerm.sh to relax some of the security to allow non-oracle users to use the client.

On Thu, May 15, 2008 at 11:12 AM, Shanmugam, Dhandapani < dhandapani.shanmugam_at_eds.com> wrote:

>
> I can't use sqlplus in Unix as a normal user. It gives the below error. My
> oracle home is /usr/local/oracle/product/10.2.0.3 Kindly suggest
>
> bash#/usr/local/oracle/product/10.2.0.3/bin> 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
>
> bash#/usr/local/oracle/product/10.2.0.3/bin> env | grep ORACLE_HOME
> ORACLE_HOME=/usr/local/oracle/product/10.2.0.3
>
>
>
>
>

-- 
Bradd Piontek
Twitter: http://www.twitter.com/piontekdd
Oracle Blog: http://piontekdd.blogspot.com
Linked In: http://www.linkedin.com/in/piontekdd
Last.fm: http://www.last.fm/user/piontekdd/

--
http://www.freelists.org/webpage/oracle-l