4 Replies Latest reply: Aug 7, 2007 11:10 PM by 511540 RSS

    Message file not found: DB Down

    581652
      My Database is down and listener service do not start.

      Am trying to connect through SQL PLUS and get following error.

      C:\Documents and Settings\nkhaja>sqlplus
      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

      Listener seems to have all valid entries.

      C:\Documents and Settings\nkhaja>lsnrctl

      LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-AUG-2007 19:16
      :09

      Copyright (c) 1991, 2005, Oracle. All rights reserved.

      Message 850 not found; No message file for product=NETWORK, facility=NL
      LSNRCTL>


      Any Suggestions.

      Regards,
      Kn
        • 1. Re: Message file not found: DB Down
          584650
          Did you try setting your ORACLE_HOME? Does the file exist? Do you have the appropriate permissions set on the Oracle product?
          • 2. Re: Message file not found: DB Down
            581652
            Am able to connect to SQL PLus and opened the DB.

            Listener Services is not Starting in services and from CMD Prompt.

            Please see the error msges.

            C:\Documents and Settings\nkhaja>lsnrctl

            LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 07-AUG-2007 19:26:57
            Message 850 not found; No message file for product=NETWORK, facility=NL
            LSNRCTL> status
            Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
            57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
            TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
            ty=TNS
            TNS-00527: Message 527 not found; No message file for product=NETWORK, facilit
            y=TNS

            LSNRCTL> reload
            Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
            57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
            TNS-12560: Message 12560 not found; No message file for product=NETWORK, facili
            ty=TNS
            TNS-00527: Message 527 not found; No message file for product=NETWORK, facilit
            y=TNS

            LSNRCTL> help
            Message 866 not found; No message file for product=NETWORK, facility=NL
            Message 861 not found; No message file for product=NETWORK, facility=NL

            LSNRCTL> start
            Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-125
            57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
            TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
            TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

            LSNRCTL> services
            Message 1053 not found; No message file for product=NETWORK, facility=TNSTNS-125
            57: Message 12557 not found; No message file for product=NETWORK, facility=TNS
            TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
            TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS

            What are this Messages errors and how to rectify this.
            • 3. Re: Message file not found: DB Down
              247514
              You need to set ORACLE_HOME environment variable, otherwise utilities like lsnrctl can't find path to message files.

              Do this in Windows

              set ORACLE_HOME=<path to your Oracle installation>
              • 4. Re: Message file not found: DB Down
                511540
                This usually saw this issue in UNIX sometime if the variable ORACLE_HOME is not set well, but in windows??

                Was your installation was successful in first attempt? Or you do have multiple Ora Home in Ur machine?