Shutdown hangs SMON WAITING FOR TX RECOVERY
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Shutdown hangs SMON WAITING FOR TX RECOVERY

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Shutdown hangs SMON WAITING FOR TX RECOVERY

    AIX 4.33
    ORACLE 8i

    we clonned one database in to this server from a similar kind of server.

    Database is starting.
    When shutdown it hangs with
    "SMON WAITING FOR TX RECOVERY" message in alert log.
    Seached the net, could not get solution.
    Thanks for the suggestions in advance.

    Regards

  2. #2
    Join Date
    Apr 2003
    Posts
    353
    Problem fixed.

    There were no private rollback segment We created one.

    We waited for 30 minutes. It cleanly shutdown.

    Now ok. But we are still analysing for the reasons.

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