Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: Oracle 8.1.7 power failure can't start TNS

    Forgive me if I am in the wrong place. I am a complete newbie to Oracle. I have looked at so many online helps/manuals I am now confused out of my mind. So I'm not sure if I should ask this here or somewhere else.

    I have 8.1.7 running on RH 7.2. It's been running fine for a month as I experiment but I just had a power failure. In trying to restart the database this seems to have restarted fine. I did however get the following log message:

    Database "orcl" possibly left running when system went down (system crash?).
    Notify Database Administrator.

    The problem I seem to have is restarting TNS. Here is the log:

    [oracle@test /]$ /home/oracle/product/8.1.7/bin/dbstart
    bash: /root/.bashrc: Permission denied

    Oracle Server Manager Release - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    Oracle8i Enterprise Edition Release - Production
    JServer Release - Production

    SVRMGR> Connected.
    SVRMGR> ORACLE instance started.
    Total System Global Area 72708256 bytes
    Fixed Size 73888 bytes
    Variable Size 55685120 bytes
    Database Buffers 16777216 bytes
    Redo Buffers 172032 bytes
    Database mounted.
    Database opened.
    Server Manager complete.

    Database "orcl" warm started.
    [oracle@test /]$ /home/oracle/product/8.1.7/bin/lsnrctl

    LSNRCTL for Linux: Version - Production on 04-MAY-2004 10:45:50

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Message 850 not found; No message file for product=network, facility=NL
    LSNRCTL> start
    Message 1070 not found; No message file for product=network, facility=TNSTNS-12546: Message 12546 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-00516: Message 516 not found; No message file for product=network, facility=TNS
    Linux Error: 13: Permission denied
    LSNRCTL> exit

    Do I need to run the Recovery Manager before starting TNS, or any other ideas?

    Last edited by Mark111; 05-20-04 at 22:05. Reason: resolved

  2. #2
    Join Date
    Mar 2004
    Berkshire, UK
    I have no idea about Linux, but those kind of errors "Message 850 not found; No message file for product" on windows come when the ORACLE_HOME environment variable is not set

    Also have a look in the listener log file, typically in the %oracle_home%/network/log/listener.log
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    May 2004

    lsnrctl start -- errors

    Hi Guys

    I was getting the same error while starting the listener after every reboot.
    I found it to be the ORACLE_HOME, and even though i was entering it in manually, by typing env from the linux command line, i noticed this...


    Notice the mistake!!! 10/1/0 should have read 10.1.0 Why did this happen
    I am lazy and when typing in the path for this, i use tab key to auto complete.... ;-) thats why the //// get put in there.

    Corrected this minor ptoblem, she starts every time now.

    Hope this helps...

    Stuart Lamble

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts