RE: sqlplus issues

From: <Peter.Hitchman_at_thomson.com>
Date: Thu, 28 Jul 2005 18:44:52 +0100
Message-ID: <3D730671F3FB8C4EA73FD2E94A11F9472D89B4@tshuklonmbx02.ERF.THOMSON.COM>

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?



	-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:47:15 CDT