Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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?/u01/app/oracle/product/10.1.0/db_1/sqlplus/mesg/sp1us.msb
-rw-r--r-- 1 oracle dba 11776 Jul 27 14:02
-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-lReceived on Thu Jul 28 2005 - 12:47:15 CDT
![]() |
![]() |