DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: shutdown immediate hangs!!!!

  1. #1
    Join Date
    Aug 2000
    Posts
    87

    Hi all,

    We have a warehouse system in our site.I dont understand what si the situation which makes the database to hangs when i give shutdown immediate.Please respond fast its urgent.

    regards,
    Vinod Kumar.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    may be your temporary tablespace extents are too small and it takes ages for SMON to dealocate them?
    or may be you have intelligent agent installed?

  3. #3
    Join Date
    Nov 2000
    Posts
    178
    You can try shutdown abort, startup and then shutdown immediate.

    Ac

  4. #4
    Join Date
    Sep 2000
    Posts
    128
    I've had this happen on occasions, but are you getting it all the time?

    when it does occur, I have to start another server manager session and shutdown abort (then startup, shutdown etc.)

    I haven't really looked into it, although I have a feeling it's linked to then intelligent agent too.


  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Try killing all the agents like listener, dbsnmp agent, data gatherer running on the instance if you have. If thats the problem.. work around is create a script that kills all your agents first and tehn use server manager to shutdown database.

    Shutdown immediate should kill the agents and bring the database down. Sometimes no where abouts why it bahaves like that. If you can't that way then 'shutdown abort' is the only solution.

  6. #6
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depending on which version of Oracle you are running, there is also a bug with Dead Connection Detection that hangs on shutdown immediate.
    Jeff Hunter

  7. #7
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    sreddy is right..
    login to server from other connection and stop
    all the listeners.this should help
    sat

  8. #8
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    Has your server been up for about 248 days?? If so, there is a bug that causes shutdown immediate to hang. This is due to a corruption in the controlfile. Plz check for this bug on Metalink.

    [Edited by Halo on 12-20-2000 at 12:16 PM]

  9. #9
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    If SGA is configured with large memory (> 2GB) , Oracle takes long time to shutdown the instance. The work around is:
    1 Issue a check point ( or switch redo log)
    2 ALTER SYSTEM FLUSH SHARED_POOL.
    3 Ensure that no lock on any table (Query from V$LOCKED_OBJECT view) is held.
    4 Kill INACTIVE sessions manually.
    5 Issue SHUTDOWN IMMEDIATE or ABORT.

    PS. If SHUTDOWN ABORT was used, then bring up instance and then shutdown normal.

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