Message file sp1.msb not found Error 6 initializing SQL*Plus

Problem: When I attempt to start SQL*PLUS I am getting an error

Message file sp1.msb not found

Error 6 initializing SQL*Plus

Action: you can follow the steps

Remember: you have to login from the owner account of oracle DB.

root@AIX:> su – oracle
/u01/mts/Pl-sql
 
oracle@AIX:> oraenv
ORACLE_SID = [root] ?
ORACLE_HOME = [/u01/app/oracle/product/8.1.5] ?
Osh [-1]
 
oracle@AIX:~> cd $ORACLE_HOME
oracle@AIX:/u01/app/oracle/product/8.1.5> 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@AIX:/u01/app/oracle/product/8.1.5> cd sqlplus/
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus> ls
admin  demo  doc  lib  mesg
 
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>sqlplus internal
Message file sp1.msb not found
Error 6 initializing SQL*Plus
 
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>mkdir tmp
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus>cd mesg/
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>ls
cpye.msb  cpyus.msb  cpyus.msg  sp1e.msb  sp1us.msb  sp1us.msg  sp2e.msb  sp2us.msb  sp2us.msg
 
oracle@AIX:/u01/app/oracle/product/8.1.5/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@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>mv sp*.* ../tmp
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>ls
cpye.msb  cpyus.msb  cpyus.msg
 
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>sqlplus internal
Message file sp1.msb not found
Error 6 initializing SQL*Plus
 
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>cp ../tmp /sp1us.msb .
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>sqlplus internal
Message file sp2.msb not found
Error 7 initializing SQL*Plus
 
oracle@AIX:/u01/app/oracle/product/8.1.5/sqlplus/mesg>cp ../tmp/sp2us.msb .
oracle@AIX:/u01/app/oracle/product/8.1.5/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
Advertisements