Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort.
Joan Chris Berry wrote: > > > > > >"Schauss, Peter" wrote: > > > > > I have one Oracle instance which supports an application > > > > > server which always maintains a database connection. > > > > > The UNIX system administrator tells me that this instance always > > > > > hangs when she tries to shut down the system. The other instances, > > > > > which do not support a 24x7 process shut down properly. > > > > > > > > > > Looking at $ORACLE_HOME/bin/dbshut, I notice that the input to > >sqlplus > > > > > is > > > > > connect internal > > > > > shutdown > > > > > > > > > > Should I modify the script to "shutdown immediate" so that it kills > > > > > any connections? > > > > > > > > > > Environment is Oracle 8.1.7 /AIX 4.3.3. > > > >From: Joan Hsieh <[EMAIL PROTECTED]> > > > >Peter, > > > >I modified to shutdown abort, starup then shutdown immediate. > > > > > > Shutdown abort is pretty drastic, are you sure shutdown immediate didn't > > > work? > > >From: Joan Hsieh <[EMAIL PROTECTED]> > >At first, we do shutdown immediate, then startup. But we do have couple > >times hang there and couldn't do the cold backup. Since changed to > >shutdown abort, startup and shutdown immediate, we don't have any > >problem at all. our database is in archive mode. Since our production > >database has to refresh to reporting database nightly. I couldn't do > >checkpoint before shutdown abort. (some error, forgot on reporting > >database) otherwise, I will add to it. > > If it's hanging on the startup I recommend trying this: > > shutdown immediate > startup nomount > alter database mount > alter database open > > You should get an error message at one of those steps that will lead you to > the real problem. > > Chris Berry > [EMAIL PROTECTED] > Systems Administrator > JM Associates > > "Without change, something sleeps inside us, and seldom awakens. The > sleeper must awaken." -- Duke Leto Atreides > > _________________________________________________________________ > Add photos to your messages with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Chris Berry > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
