Hi
David,
These
are what I think
first,
you are not using shutdown immediate (Oracle waiting user to close
the session) - unlikely for this case.
or
It has
been so long you never shutdown your database, Oracle doing housekeeping, your
rollback segment, update your data files, things like
that
or
you
are using archive log mode with 8.1.6, and legend said bug cause the
shutdown took hours (oracle code performing endless loop I quest), I
encounter this problem then I did :
startup force follow with shutdown immediate
(hmm... I think, I am a lousy dba, he he he...)
the problem never occur again, and my database
life happily ever after.
Sinardy
-----Original Message-----
From: Nguyen, David M [mailto:[EMAIL PROTECTED]
Sent: 26 February 2003 09:44
To: Multiple recipients of list ORACLE-L
Subject: It takes too long to shutdown databaseI try to bounce database by shutting it down and starting it back up but it just hang in there for almost 45 minutes trying to shut down. It is running on Solaris8, I can press Ctrl+C to interrupt it or issue a kill command to kill it but I hesitate to do so. Do you have any advices and why it takes too long to shutdown database? It usually only takes me about 3 minutes to bounce database.
Thanks,
David
