DB Shutdown Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: DB Shutdown Problem

  1. #1
    Join Date
    Nov 2005
    Posts
    10

    DB Shutdown Problem

    Hi Friends,

    I have a problem with shutting down the database.

    When the DB is up for say a couple of months, and if try to use shutdown immediate it takes a long time and does not bring the DB down.

    Ultimately I have to use shutdown abort ---> startup and then use
    shutdown immediate, which works fine.

    Can anyone help me with reason for the same and resolution to this.

    Regds,

  2. #2
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    It might be, because Processes are taking much time in rollbacking
    current transactions(because of heavy DML's), when u give shutdown immediate command.

    1. Yes, The best thing you can do is, shutdown abort ->startup restrict -> shutdown normal
    ~KD.DBA~

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, the best thing you can do is analyze the problem and see what is going on

  4. #4
    Join Date
    Sep 2005
    Location
    Delhi
    Posts
    78
    ok..then Davey what could be the reason?????
    ~KD.DBA~

  5. #5
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Quote Originally Posted by dhar_kiran
    ok..then Davey what could be the reason?????
    Have you read the alert log lately?
    this space intentionally left blank

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    just guessing and using shutdown abort isnt a solution

  7. #7
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015
    Quote Originally Posted by davey23uk
    just guessing and using shutdown abort isnt a solution
    I was at Oracle Open World a few years ago, and one of the presenters suggested that people always use shutdown abort.
    this space intentionally left blank

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    name and shame my dear fellow

  9. #9
    Join Date
    Nov 2005
    Posts
    10
    Below is a snapshot of alert log file.

    Is it something related to License high water mark = 364.

    Sun Apr 23 02:01:07 2006
    Shutting down instance (immediate)
    License high water mark = 364
    Sun Apr 23 02:06:16 2006
    SHUTDOWN: waiting for active calls to complete.
    Sun Apr 23 02:38:41 2006
    Shutting down instance (immediate)
    License high water mark = 364
    Sun Apr 23 02:40:23 2006
    Shutting down instance (abort)
    License high water mark = 364
    Instance terminated by USER, pid = 13418
    Sun Apr 23 02:40:37 2006
    Starting ORACLE instance (normal)
    LICENSE_MAX_SESSION = 0
    LICENSE_SESSIONS_WARNING = 0
    LICENSE_MAX_USERS = 0
    Starting up ORACLE RDBMS Version: 8.1.6.0.0.
    System parameters with non-default values:
    processes = 350
    sessions = 450
    timed_statistics = TRUE
    .
    .
    .
    .
    .
    .

  10. #10
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Sun Apr 23 02:06:16 2006
    SHUTDOWN: waiting for active calls to complete.
    there you go, check v$transaction to see what is going on at that time

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