RE: sqlplus issues
- From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Thu, 28 Jul 2005 12:13:11 -0400
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
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@xxxxxxxxxxxxx> 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
Other related posts:
