Hi Tony,
Wild shot in the dark here, but check to see if any segments contain
a large number of extents (more than a thousand).
In this situation the amount of housekeeping required to shut down
the database takes so long (I've heard of people waiting many hours)
that it appears to have hung.
If I remember correctly, Kevin Loney did a good write up on the problem.



> -----Original Message-----
> From: Tony [mailto:tony.[Email Address Removed] Subject: Unable to shutdown database - any suggestions please?
>
>
> Hi All
>
> I cannot shutdown a database, except by means of using
> "shutdown abort"
>
> This is also the case even if the database is not even open.
>
> I cannot find any obvious reason for this, has naybody else
> got any ideas
> please?
>
> Thanks
>
> Tony
Oracle LazyDBA home page