Looking for a good database shutdown script for Unix
Date: 18 May 1993 09:03:54 -0700
Message-ID: <1tb1da$2r1_at_spock.dis.cccd.edu>
At the present time, we run ~oracle/bin/dbshut before shutting down the
underlying Unix system. This script does a sqldba "shutdown" command for each
database listed in oratab.
But recently we've encountered some sort of hang problem where the database gets
seriously confused, and a standard sqldba "shutdown" command hangs forever. We
then have to kill off sqldba, and manually kill the associated oracle processes.
Yuck. :-(
I'm wondering if anybody out there has implemented an Oracle shutdown script
that is smarter about shutting down hung databases. I.e. one that tries
Please post or e-mail; I'll summarize any e-mail replies. Thanks.
"shutdown normal", and if it is still hung after x seconds, kills that attempt,
and then escalates to "shutdown immediate" or even "shutdown abort".
--
Mark Bixby Internet: markb_at_cccd.edu
Coast Community College District 1370 Adams Avenue
District Information Services Costa Mesa, CA, USA 92626
Technical Support (714) 432-5064
"You can tune a file system, but you can't tune a fish." - tunefs(1M)
Received on Tue May 18 1993 - 18:03:54 CEST