******SHUT DOWN TOO LONG*******
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ******SHUT DOWN TOO LONG*******

  1. #1
    Join Date
    Feb 2002
    Posts
    18
    I had to shut down the db .
    I did immediate shut down not abort but it takes too long more that 30 minutes.
    The messg in the alert:
    SHUTDOWN: waiting for active calls to complete

    Please advise
    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Since you didn't specify your version, I'll assume Oracle 8.1.7.4 on Solaris.

    http://otn.oracle.com/docs/products/...start.htm#7871
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    290
    Shutdown Immediate will wait until all the transactions are rolled back. May be being locked up.

    Now you may wish to use ABORT option...






    Madhu Reddy
    xdollor@yahoo.com

  4. #4
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Hi in that type of situations....
    do...
    1.shutdown abort
    2.startup restrict
    3.shutdown [normal]
    that way ur purpose is solved...
    note:You have to follow the steps 1,2 and 3..and you know reason for those steps too?..
    Thanks.
    Thanigaivasan.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    before you abort you better do checkpoint or switch log

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