dbstart and dbshut using oratab
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: dbstart and dbshut using oratab

  1. #1
    Join Date
    Aug 2005
    Posts
    10

    dbstart and dbshut using oratab

    In my oratab file have listed 4 DB and when i issue dbstart and dbshut, why is it only the first 3 DB listed in oratab will be shutdown or re-start and it will ignore the 4th DB listed in the oratab ?

    My DB is 8i in unix env.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    show the contents of your oratab, is the last column set to N for the database that wont start?

  3. #3
    Join Date
    Aug 2005
    Posts
    10
    it is also set as "Y" for the last listing. Please advise.

  4. #4
    Join Date
    Apr 2001
    Posts
    110
    Are all 4 DBs using the same Oracle Home?

    Have you tried startup and shutdown the 4th DB manually?

    Better to show the oratab content, if not everyone here will be just guessing your problem.
    What's next after 10g?

  5. #5
    Join Date
    Aug 2005
    Posts
    10
    Yes all 4 DBs are in the same ora home.

    Yes i am able to shut and start all 4 DBs manually.

    Attached below is my oratab file :-

    #

    # This file is used by ORACLE utilities. It is created by root.sh
    # and updated by the Database Configuration Assistant when creating
    # a database.

    # A colon, ':', is used as the field terminator. A new line terminates
    # the entry. Lines beginning with a pound sign, '#', are comments.
    #
    # Entries are of the form:
    # $ORACLE_SID:$ORACLE_HOME::
    #
    # The first and second fields are the system identifier and home
    # directory of the database respectively. The third filed indicates
    # to the dbstart utility that the database should , "Y", or should not,
    # "N", be brought up at system boot time.
    #
    # Multiple entries with the same $ORACLE_SID are not allowed.
    #
    #
    *:/oracle/app/oracle/product/8.1.7:N
    whl2:/oracle/app/oracle/product/8.1.7:Y
    whlr:/oracle/app/oracle/product/8.1.7:Y
    ialdb2:/oracle/app/oracle/product/8.1.7:Y
    whlp:/oracle/app/oracle/product/8.1.7:Y


    TQ.

  6. #6
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    I wonder whether there's a hidden character in the fourth line (introduced as a typo perhaps). Have you tried deleting and re-typing the line?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  7. #7
    Join Date
    Aug 2005
    Posts
    10
    I have found out that we need to press on the last DB list in the oratab file and create a empty new line in the oratab file in order for dbstart and dbshut to read all DB in oratab file.

    Have you guys notice this ?

  8. #8
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    Sorry, how do you mean 'press on the last DB'? Delete it then reinsert it? Or add a new empty line below it?
    If I have to choose between two evils, I always like to choose the one I haven't tried yet.

  9. #9
    Join Date
    Aug 2005
    Posts
    10
    Sorry, what i meant what press enter-key on the last DB list in the oratab file and create a empty new line in the oratab file after the last entry in the oratab file. When i issue dbstart and dbshut again, it will able to shut and start all DB in oratab file.

  10. #10
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    try re-running root.sh to re-create oratab.
    "High Salaries = Happiness = Project Success."

Posting Permissions

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



Click Here to Expand Forum to Full Width