SP1.MSB NOT FOUND

[oravijay]

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.

[pando]

check $ORACLE_HOME/sqlplus/mesg

it has to be there the file otherwise you get the error
this file is simply contains sqlplus messages

[oravijay]

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.

[pando]

it works for me so I cant help

have you thought why you get that error? bad installation?

[oravijay]

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.

[pando]

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

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

[pando]

another example, now I use sp1e.msb and sp2e.msb

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

[nandu]

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