This discussion is archived
1 2 Previous Next 20 Replies Latest reply: Jul 18, 2012 6:10 AM by shailajasomisetty RSS

Message file sp1 lang .msb not found

3004 Newbie
Currently Being Moderated
When trying to run sqlplusw.exe I receive the following message ' Message file sp1<lang>.msb not found'. The file sp1us.msb does exist in oracle\ora81\sqlplus\mesg.

Has anyone got any ideas??
  • 1. Message file sp1 lang .msb not found
    3004 Newbie
    Currently Being Moderated
    This can happen if you haven't set the ORACLE_HOME and ORACLE_SID system variables. Make sure they're set correctly (should happen during installation) and try again.

    Alison
    iSQL*Plus Team
  • 2. Re: Message file sp1 lang .msb not found
    479892 Newbie
    Currently Being Moderated
    How i can set the ORACLE_HOME and ORACLE_SID system variables. I also got this error.But i can see sp1us.msb on my this directory C:\Oracle\product\10.1.0\Client_2\install\sqlplus\mesg.

    How to solve it... I hope you can help me..And i appreciate you help.
  • 3. Re: Message file sp1 lang .msb not found
    479892 Newbie
    Currently Being Moderated
    This is my listener.ora

    # LISTENER.ORA Network Configuration File: C:\Oracle\product\10.1.0\Client_2\install\network\admin\listener.ora
    # Generated by Oracle configuration tools.

    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server_psm)(PORT = 1521))
    )
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = C:\Oracle\product\10.1.0\Client_2\install)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = PSM2006)
    (ORACLE_HOME = C:\Oracle\product\10.1.0\Client_2\install)
    (SID_NAME = PSM2006)
    )
    )
  • 4. Re: Message file sp1 lang .msb not found
    4783 Newbie
    Currently Being Moderated
    I have answered this in many of your other postings.

    Please do not post the same question multiple times. Start a new thread with all the relevant information for us to help you instead.

    Alison
  • 5. Re: Message file sp1 lang .msb not found
    476428 Newbie
    Currently Being Moderated
    I hava the same problem in windws 2000 with ORACLE Express data base; in my enviroments variables I wrote:

    C:\oraclexe\app\oracle\product\10.2.0\server

    and add this to PATH:

    ORACLE_HOME\bin

    But when execute the command sqlplus under

    C:\oraclexe\app\oracle\product\10.2.0\server\BIN>sqlplus

    send me the error message

    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

    I rewied that sp1<lang>.msb found in the directory and it is ok

    I tried set enviroment under DOS window, but the problem persist
  • 6. Re: Message file sp1 lang .msb not found
    550531 Newbie
    Currently Being Moderated
    I had a similiar issue. I had a CMD file that would setup my login & pwd based on params, then CD, then run SqlPlus. When I ran the CMD file, I would get the "Message file sp1 lang .msb not found" error, but if I manually executed the same line the CMD file was using to launch SqlPlus, everything worked great. The CMD was using an environment var to specify the full path of the SqlPlus executable. What I discovered is that the SqlPlus.exe executable didn't like the fact that I was using an environment variable called "SQLPLUS":

    Set SQLPLUS=C:\Oracle\Sqlplus.exe
    ... do some stuff...
    %SQLPLUS% %OPTIONS% %UID%@%SID%

    As it turns out, the name "SQLPLUS" (along with about 6 billion other names) is a special / sacred environment variable name for Oracle... I took out the SQLPLUS env var and the CMD file worked.
  • 7. Re: Message file sp1 lang .msb not found
    648811 Newbie
    Currently Being Moderated
    Gentleman,

    Im having the same problem.
    But none of the solutions above has worked.

    Im using windows xp. i´ve tried to reinstall, but with no results.
    anything else?
  • 8. Re: Message file sp1 lang .msb not found
    Paul M. Oracle ACE
    Currently Being Moderated
    Try this :

    C:\>set ORACLE_HOME=<your Oracle Home>
    C:\>set PATH=%ORACLE_HOME%\bin;%PATH%
    C:\>set ORACLE_SID=<your SID>
    C:\>sqlplus "/ as sysdba"

    Result ?
  • 9. Re: Message file sp1 lang .msb not found
    677542 Newbie
    Currently Being Moderated
    A trailing '/' on the end of my ORACLE_HOME caused this problem for me.
  • 10. Re: Message file sp1 lang .msb not found
    686444 Newbie
    Currently Being Moderated
    I had installed an earlier version of Oracle client which had an environment variable set in the system variables in the environment variable dialog available from the Advances tab in the system properties dialog. During the install of 10 this got unset. I didn't notice it was still there and unset and I set a new one as a user variable. After I deleted the unset one which was overriding my user one I was in the clear.

    Note that even in my cygwin shell, the user set variable was correct, but the unset version was causing the issue.
  • 11. Re: Message file sp1 lang .msb not found
    763806 Newbie
    Currently Being Moderated
    Hi, I was getting same error and when i set my Oracle_Home , its gone.
    Now its working good.

    Thanks a lot for response......
  • 12. Re: Message file sp1 lang .msb not found
    852403 Newbie
    Currently Being Moderated
    Hi all,

    I had the same issue and I resolved it on Windows by removing the semi-colon (;) at the end of the ORACLE_HOME environment variable.

    Thanx

    Edited by: user5776508 on Apr 2, 2011 3:04 AM
  • 13. Re: Message file sp1 lang .msb not found
    864651 Newbie
    Currently Being Moderated
    Please am a novice, when i try to launch sqlplus.exe for the first time, I get an error message: "Message file sp1 lang .msb not found". Please what do I do afterwards?
  • 14. Re: Message file sp1 lang .msb not found
    864651 Newbie
    Currently Being Moderated
    Please am a novice, when i try to launch sqlplus.exe for the first time, I get an error message: "Message file sp1 lang .msb not found". Please what do I do afterwards?
1 2 Previous Next