Re: Oracle instance won't shutdown

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 1 Dec 2000 16:41:42 GMT
Message-ID: <3A27D4C6.E27A3AC6@edcmail.cr.usgs.gov>

> This one instance just hangs unless we issue the abort option. We have
> several other instances on this box that do not have this problem.

Are you sure that the database is "hanging"? When you do a shutdown immediate, current transactions are rolled back. The rolling back of these transactions can take a long time. Personally, I've seen it take over an hour for a shutdown immediate to complete. This was because a very large transaction was rolling back. How long have you waited before you issued the shutdown abort?

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Fri Dec 01 2000 - 10:41:42 CST