RE: Can't login SqlPlus

  • From: "Shanmugam, Dhandapani" <dhandapani.shanmugam@xxxxxxx>
  • To: "Koivu, Lisa" <Lisa.Koivu@xxxxxxxxxxxxxx>, <JSweetser@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • 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,
Dhandapani S
+ mailto:dhandapani.shanmugam@xxxxxxx 

 


________________________________

        From: Koivu, Lisa [mailto:Lisa.Koivu@xxxxxxxxxxxxxx] 
        Sent: Thursday, May 15, 2008 10:41 PM
        To: JSweetser@xxxxxxxx; Shanmugam, Dhandapani;
oracle-l@xxxxxxxxxxxxx
        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

         

         

         

        
________________________________


        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sweetser, Joe
        Sent: Thursday, May 15, 2008 12:40 PM
        To: dhandapani.shanmugam@xxxxxxx; oracle-l@xxxxxxxxxxxxx
        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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Shanmugam,
Dhandapani
        Sent: Thursday, May 15, 2008 10:13 AM
        To: oracle-l@xxxxxxxxxxxxx
        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. 

Other related posts: