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

    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 3.1.7.0.0 - Production

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

    Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
    JServer Release 8.1.7.0.1 - 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.
    SVRMGR>
    Server Manager complete.

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

    LSNRCTL for Linux: Version 8.1.7.0.0 - 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?

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

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    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
    Posts
    1

    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...

    ORACLE_HOME=/app/oracle/product/10/1/0/db_1

    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...

    Cheers
    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
  •