Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: sqlplus issues

RE: sqlplus issues

From: Harvinder Singh <Harvinder.Singh_at_MetraTech.com>
Date: Thu, 28 Jul 2005 13:21:35 -0400
Message-ID: <D6424CD4C8A3C044BBC49877ED51C51801DBABF1@ex2003.metratech.com>


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_at_gmail.com] 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_at_metratech.com> 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_at_gmail.com] Sent: Wednesday, July 27, 2005 7:30 PM
To: Harvinder Singh
Cc: Oracle-L (E-mail)
Subject: Re: sqlplus issues    

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 28 2005 - 12:25:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US