This discussion is archived
4 Replies Latest reply: Aug 7, 2007 11:10 PM by 511540 RSS

Message file not found: DB Down

581652 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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?