RE: Can't login SqlPlus
Date: Thu, 15 May 2008 13:10:48 -0400
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
[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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Shanmugam,
Sent: Thursday, May 15, 2008 10:13 AM
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
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.Received on Thu May 15 2008 - 12:10:48 CDT