1 2 Previous Next 20 Replies Latest reply: Jul 18, 2012 8:10 AM by shailajasomisetty RSS

    Message file sp1 lang .msb not found

    3004
      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
          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
            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
              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
                Alison Holloway-Oracle
                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
                  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
                    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
                      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.
                        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
                          A trailing '/' on the end of my ORACLE_HOME caused this problem for me.
                          • 10. Re: Message file sp1 lang .msb not found
                            686444
                            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
                              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
                                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
                                  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
                                    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