Re: Can't login SqlPlus

Looks like the ORACLE_HOME variable is only set not exported

set ORACLE_HOME=/usr/local/oracle/product/10.2.0.3 export ORACLE_HOME

Hope this Helps

-- 
Mir M. Mirhashimali
Oracle Systems Manager
Database Architecture, Enterprise Applications
Rice University
(713) 348 6365



Shanmugam, Dhandapani 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

>

>

>

>

>

> !DSPAM:59,482c63ca208031097336382! 

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