RE: sqlplus issues

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  

Have you checked to see if the file is there?

ls -l $ORACLE_HOME/sqlplus/mesg/sp1*.ms?
-rw-r--r-- 1 oracle dba 11264 Apr 26 2002
/u01/app/oracle/product/9.2.0/sqlplus/mesg/sp1us.msb
-rw-r--r-- 1 oracle dba 16590 Mar 6 2002
/u01/app/oracle/product/9.2.0/sqlplus/mesg/sp1us.msg

Are the permissions correct if the files do exist?

On 7/27/05, Harvinder Singh <Harvinder.Singh_at_metratech.com> wrote:

Hi,  

We installed the oracle 10g on solaris 10 and getting following error:  

$ 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  

ORACLE_HOME and other parameters are set in .profile:

$ echo $ORACLE_HOME

/u01/app/oracle/product/10.1.0/db_1

$ echo $PATH

/u01/app/oracle/product/10.1.0/db_1/bin:/usr/bin  

What can be the possible issue?  

Thanks

--Harvinder
 

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 28 2005 - 11:17:35 CDT