Re: Can't login SqlPlus

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: dhandapani.shanmugam@xxxxxxx
  • Date: Thu, 15 May 2008 11:33:20 -0500

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/

Other related posts: