RE: Can't login SqlPlus
Date: Fri, 16 May 2008 00:35:22 +0530
Thanks All. I executed $ORACLE_HOME/install/changePerm.sh file and set my ORACLE_HOME and PATH variables ..It is working fine now..thanks all for the wounder full solutions.
Thanks and Regards,
From: Koivu, Lisa [mailto:Lisa.Koivu_at_starwoodvo.com] Sent: Thursday, May 15, 2008 10:41 PM To: JSweetser_at_icat.com; Shanmugam, Dhandapani; oracle-l_at_freelists.org Subject: RE: Can't login SqlPlus I've also seen this when the permissions were not set correctlyon 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_HOMEis in your path before the newer one.
[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 belowerror. 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 Oraclesoftware directory
bash#/usr/local/oracle/product/10.2.0.3/bin> env | grep
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