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@xxxxxxx> 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/