Shutdown immediate hang
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Shutdown immediate hang

Hybrid View

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Shutdown immediate hang

    Why sometimes when I tried to shutdown immediate a DB, the process hang there? It does not show any status and I had been waiting for long time. I also tried to disconnect all users.

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    wat does alert log say?
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Shutdown immediate hang

    startup force and then try shutdown immediate
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758

    Re: Re: Shutdown immediate hang

    Originally posted by julian
    startup force and then try shutdown immediate
    If I am not wrong, startup force = shutdown abort + startup ??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317

    Re: Re: Re: Shutdown immediate hang

    Originally posted by SANJAY_G
    If I am not wrong, startup force = shutdown abort + startup ??
    You're correct.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

  6. #6
    Join Date
    Feb 2004
    Posts
    2

    Re: Re: Re: Re: Shutdown immediate hang

    Originally posted by efrijters
    You're correct.
    When you use "SHUTDOWN IMMEDIATE", Oracle will kill all active sessions and rollback all transactions. If you are shutting down database which has high volumn transaction, it may take more than 15 mins to shut down cleanly.

    After you issue "SHUTDOWN IMMEDAITE", try to monitor OS process for checking out what kind of process is running with high CPU time.

    For your case, I trust it may be SMON. If so, just wait for it to complete.

    Cheers,

    Reid Lai
    Oracle DBA in HK

  7. #7
    Join Date
    Sep 2003
    Location
    Bangalore
    Posts
    36
    Hi,

    Can you please specify the version of oracle you are using.
    Can you check the output of ps -ef|grep ORA when you are trying to shutdown the database. There are be many reasons for the shutdown to hang. There can be a large transaction running. At time even when you kill the client side connection the same may continue to run on the server and will be visible from ps -ef|grep ORA.
    Try to kill all the transaction which show local=no in the output of ps -ef|grep ORA.
    Then see if the database goes down. I am assuming that you are the only person connected to the database and than through internal, or as / in 9i.

    There are certain bug also associated with shutdown immediate in oracle so please post the oracle version.

    Thanks
    Regards

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