-
Hi All,
When I attempt to start SQL*PLUS I am getting SP1.MSB not found error.
Whenever I get this error I used to re-install Oracle and then work.
I would like to know whether there's a direct method for resolving this error.
Any help will be highly appreciated.
Thanks.
Vijay.
Say No To Plastics
-
check $ORACLE_HOME/sqlplus/mesg
it has to be there the file otherwise you get the error
this file is simply contains sqlplus messages
-
Hi Pando,
I have the files in the directory. I have also tried copying the files from some other system
and paste it there. But still ...........
I wanted to know whether there's a workaround apart from re-installing the software.
Vijay.
Say No To Plastics
-
it works for me so I cant help
have you thought why you get that error? bad installation?
-
Hi,
The Oracle software was installed properly and we were working with the databases etc...
All of a sudden, this problem came.
I have encountered this situation a few times before. I had discussed with a few of my Sr. DBA's too.
The answer I got was.........REINSTALL.
Can u tell me what u did?
Vijay.
Say No To Plastics
-
Code:
oracle@simdes:~> cd $ORACLE_HOME
oracle@simdes:/oracle/simp> ls
Apache arch glibc-2.1.3-stubs.tar.gz javavm jsp ocommon owm relnotes slax svrmgr
JRE assistants hs jdbc ldap odg plsql root.sh sqlj wwg
README.stub bin install jis lib oracore precomp root.sh.old sqlplus xdk
admin dbs install.platform jlib network otrace rdbms setup_stubs.sh starterdb
oracle@simdes:/oracle/simp> cd sqlplus/
oracle@simdes:/oracle/simp/sqlplus> ls
admin demo doc lib mesg
oracle@simdes:/oracle/simp/sqlplus> cdmkdir tmp
bash: cdmkdir: command not found
oracle@simdes:/oracle/simp/sqlplus> mkdir tmp
oracle@simdes:/oracle/simp/sqlplus> cd mesg/
oracle@simdes:/oracle/simp/sqlplus/mesg> ls
cpye.msb cpyus.msb cpyus.msg sp1e.msb sp1us.msb sp1us.msg sp2e.msb sp2us.msb sp2us.msg
oracle@simdes:/oracle/simp/sqlplus/mesg> ls -l
total 152
-rw-r--r-- 1 oracle oinstall 4096 mar 21 14:53 cpye.msb
-rw-r--r-- 1 oracle oinstall 4096 mar 21 14:53 cpyus.msb
-rw-r--r-- 1 oracle oinstall 1672 mar 21 14:53 cpyus.msg
-rw-r--r-- 1 oracle oinstall 11264 mar 21 14:53 sp1e.msb
-rw-r--r-- 1 oracle oinstall 10240 mar 21 14:53 sp1us.msb
-rw-r--r-- 1 oracle oinstall 15097 mar 21 14:53 sp1us.msg
-rw-r--r-- 1 oracle oinstall 29184 mar 21 14:53 sp2e.msb
-rw-r--r-- 1 oracle oinstall 25600 mar 21 14:53 sp2us.msb
-rw-r--r-- 1 oracle oinstall 40666 mar 21 14:53 sp2us.msg
oracle@simdes:/oracle/simp/sqlplus/mesg> mv sp*.* ../tmp
oracle@simdes:/oracle/simp/sqlplus/mesg> ls
cpye.msb cpyus.msb cpyus.msg
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp1.msb not found
Error 6 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp1us.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp2.msb not found
Error 7 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp2us.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
SQL*Plus: Release 8.1.7.0.0 - Production on Thu May 16 12:20:33 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
sys@DSIM>select sysdate from dual;
SYSDATE
---------
16-MAY-02
1 row selected.
sys@DSIM>quit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
it works for me so I cant help, I didNOT copy msg because it is the ascii file of MSB files
Code:
oracle@simdes:/oracle/simp/sqlplus/mesg> cat sp1us.msg | more
/
/ Copyright (c) Oracle Corporation 1989, 1999. All Rights Reserved.
/
/ File : SP1US.MSG
/ Created : 05/22/90
/ By : SYSTEM
/ Language : American
/ Character set : US7ASCII
/
/ CONTENTS
/ Feedback messages for SQL*Plus
/
/ NOTES
/ The first colum is the SQL*Plus error number.
/ The second column is reserved and must (for now) be 0.
/ The remainder of the line is the error text.
/
/
00000,0, "Operation %ld succeeded."
// *Cause:
// *Action:
00001,0, "Table created."
// *Cause:
// *Action:
00002,0, "Table created."
// *Cause:
// *Action:
00003,0, "1 row created."
// *Cause:
// *Action:
00004,0, "%ld rows created."
// *Cause:
// *Action:
00005,0, "1 row selected."
// *Cause:
// *Action:
00006,0, "%ld rows selected."
// *Cause:
// *Action:
00007,0, "Cluster created."
// *Cause:
// *Action:
00008,0, "Cluster created."
// *Cause:
// *Action:
00009,0, "Cluster altered."
.............. etc etc
-
another example, now I use sp1e.msb and sp2e.msb
Code:
oracle@simdes:/oracle/simp/sqlplus/mesg> echo $NLS_LANG
AMERICAN_AMERICA.WE8ISO8859P1
oracle@simdes:/oracle/simp/sqlplus/mesg> export NLS_LANG=SPANISH_SPAIN.WE8ISO8859P1
oracle@simdes:/oracle/simp/sqlplus/mesg> ls
cpye.msb cpyus.msb cpyus.msg sp1e.msb sp1us.msb sp1us.msg sp2e.msb sp2us.msb sp2us.msg
oracle@simdes:/oracle/simp/sqlplus/mesg> mkdir ../tmp
oracle@simdes:/oracle/simp/sqlplus/mesg> mv sp* ../tmp
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp1.msb not found
Error 6 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp1e.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
Message file sp2.msb not found
Error 7 initializing SQL*Plus
oracle@simdes:/oracle/simp/sqlplus/mesg> cp ../tmp/sp2e.msb .
oracle@simdes:/oracle/simp/sqlplus/mesg> sqlplus internal
SQL*Plus: Release 8.1.7.0.0 - Production on Jue May 16 12:32:14 2002
(c) Copyright 2000 Oracle Corporation. All rights reserved.
Conectado a:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
sys@DSIM>select sysdate from dual;
SYSDATE
--------
16/05/02
1 fila seleccionada.
sys@DSIM>quit
Desconectado de Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
oracle@simdes:/oracle/simp/sqlplus/mesg>
see I get spanish messages now and instead of putting sp1us.msb and sp2us.msb it works with sp1e* that is because I changed my NLS_LANG
-
More than one database?!
Vijay,
Do u have more than one database in your machine?
Check out the value for ORACLE_SID and ORACLE_HOME
and set them to the respective values you want.
Export those values and login using sqlplus again.
This had happened to me more than once.
See if it helps.
Cheers,
Nandu
Never give up !
Nanda Kumar - Vellore
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|