RE: Can't login SqlPlus

From: Shanmugam, Dhandapani <>
Date: Fri, 16 May 2008 00:35:22 +0530
Message-ID: <>


Thanks All. I executed $ORACLE_HOME/install/ file and set my ORACLE_HOME and PATH variables ..It is working fine now..thanks all for the wounder full solutions.  

Thanks and Regards,
Dhandapani S

	From: Koivu, Lisa [] 
	Sent: Thursday, May 15, 2008 10:41 PM
	To:; Shanmugam, Dhandapani;
	Subject: 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                                       

[] On Behalf Of Sweetser, Joe

	Sent: Thursday, May 15, 2008 12:40 PM
	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.          


[] On Behalf Of Shanmugam, Dhandapani

	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/ Kindly suggest
	bash#/usr/local/oracle/product/> 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/> env | grep ORACLE_HOME

        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 - 14:05:22 CDT

Original text of this message