DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: SP1.MSB NOT FOUND

  1. #1
    Join Date
    Mar 2002
    Posts
    301
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    check $ORACLE_HOME/sqlplus/mesg

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

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it works for me so I cant help

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

  5. #5
    Join Date
    Mar 2002
    Posts
    301
    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

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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

  8. #8
    Join Date
    May 2002
    Posts
    108

    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
  •  


Click Here to Expand Forum to Full Width