Re: Database Shutdown Normal ...hangs ....why?

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Mon, 9 Jul 2001 11:39:17 -0700
Message-ID: <9ictlf$4lb$1_at_spiney.sierra.com>


Why would/how could a fragmented table prevent a shutdown?

"M. Moiz" <moiznet2002_at_yahoo.com> wrote in message news:53b2483d.0107090921.149fc19e_at_posting.google.com...
> Don <don_at_xxx.com> wrote in message
 news:<oc7jktsb5n33iatpa0kv4t9rupn0an6upf_at_4ax.com>...
> > I have an 8.1.6 server that I am trying to shut down under normal
> > circumstances. It just hangs and doesn't complete the shut down
> > through DBA Studio. I have left the normal shut down going over a
> > weekend and it is still not completed. Once this is started I can't
> > cxl the shutdown normal process....(I have to reboot to get the db up
> > again).
> >
> > It will only complete a shut down using "SHUTDOWN ABORT".
> >
> > - it is in "NO ARCHIVE" mode
> > - it is usually on 24 hours a day..(though that is not a requirement)
> > - there are no users on the system when i am attempting the normal
> > shut down
> >
> > i am trying to get a clean shutdown to begin a backup and recovery
> > plan and start archiving.
> >
> >
> > any ideas why shutdown normal would hang ???
>
> Could be cauz one or more of the tables are fragmented...
>
> Also check for any misplaced parameters in the init.ora file...
Received on Mon Jul 09 2001 - 20:39:17 CEST

Original text of this message