RE: sqlplus issues

Hi,
As a possible short cut, I suggest that you use the "truss" command to
see what sqlplus is doing, it should show you what environment it picks
up (-e flag) and where it is trying to find the files.
 
Regards
 
Pete

        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Harvinder Singh
        Sent: 28 July 2005 18:22
        To: Jared Still
        Cc: Oracle-L (E-mail)
        Subject: RE: sqlplus issues
        
        

        Here is the correct output:

         

        $ ls -l $ORACLE_HOME/sqlplus/mesg/sp1*.ms?

        -rw-r--r--   1 oracle   dba        11776 Jul 27 14:02
/u01/app/oracle/product/10.1.0/db_1/sqlplus/mesg/sp1us.msb

        -rw-r--r--   1 oracle   dba        17414 Jul 27 14:02
/u01/app/oracle/product/10.1.0/db_1/sqlplus/mesg/sp1us.msg

         

         

        
________________________________


        From: Jared Still [mailto:jkstill@xxxxxxxxx] 
        Sent: Thursday, July 28, 2005 12:46 PM
        To: Harvinder Singh
        Cc: Oracle-L (E-mail)
        Subject: Re: sqlplus issues

         

        
        Yes, but that is not what was asked for.
        
        What directory are you in when doing ls?
        
        Does this output match what appears with this command?
        
        ls -l $ORACLE_HOME/sqlplus/mesg/sp1*.ms?
        
        Jared
        
        

        On 7/28/05, Harvinder Singh <Harvinder.Singh@xxxxxxxxxxxxx>
wrote:

        Here is the output. Permissions looks ok to me. Not sure what to
try next.

         

        $ 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

        $ ls -lrt

        total 400

        -rw-r--r--   1 oracle   dba         4096 Jul 27 14:02 cpyus.msb

        -rw-r--r--   1 oracle   dba         4369 Jul 27 14:02 cpyus.msg

        -rw-r--r--   1 oracle   dba        11776 Jul 27 14:02 sp1us.msb

        -rw-r--r--   1 oracle   dba        17414 Jul 27 14:02 sp1us.msg

        -rw-r--r--   1 oracle   dba        28672 Jul 27 14:02 sp2us.msb

        -rw-r--r--   1 oracle   dba       116170 Jul 27 14:02 sp2us.msg

        -rw-r--r--   1 oracle   dba         3584 Jul 27 14:02 sp3us.msb

        -rw-r--r--   1 oracle   dba          506 Jul 27 14:02 sp3us.msg

         

         

        
________________________________


        From: Jared Still [mailto:jkstill@xxxxxxxxx] 
        Sent: Wednesday, July 27, 2005 7:30 PM
        To: Harvinder Singh
        Cc: Oracle-L (E-mail)
        Subject: Re: sqlplus issues

Other related posts: