RE: sqlplus issues
- From: <Peter.Hitchman@xxxxxxxxxxx>
- To: <Oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Jul 2005 18:44:52 +0100
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:
