RE: Can't login SqlPlus

I've also seen this when the permissions were not set correctly on the oracle install. I had to chmod -R 755 the entire ORACLE_HOME directory because the group and world permissions were set incorrectly. I'm on Solaris 10.  

I found this fix from metalink note 356850.1.  

HTH       Lisa Koivu

Oracle Database Administrator

Starwood Vacation Ownership

Orlando, FL, USA      

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sweetser, Joe
Sent: Thursday, May 15, 2008 12:40 PM
To: dhandapani.shanmugam_at_eds.com; oracle-l_at_freelists.org Subject: RE: Can't login SqlPlus  

PATH setting? I think I've seen this if an "older" ORACLE_HOME is in your path before the newer one.  

-joe  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shanmugam,
Dhandapani
Sent: Thursday, May 15, 2008 10:13 AM
To: oracle-l_at_freelists.org
Subject: Can't login SqlPlus  

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

This electronic message transmission contains information from the Company that may be proprietary, confidential and/or privileged. The information is intended only for the use of the individual(s) or entity named above. If you are not the intended recipient, be aware that any disclosure, copying or distribution or use of the contents of this information is prohibited. If you have received this electronic transmission in error, please notify the sender immediately by replying to the address listed in the "From:" field.

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