Re: dbshut script - shutdown or shutdown immediate

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.

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 <joan.hsieh_at_tufts.edu>
> >Peter,
> >I modified to shutdown abort, starup then shutdown immediate.
>
> Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
> work?
>
> Chris Berry
> compjma_at_hotmail.com
> Systems Administrator
> JM Associates
>
> "Without change, something sleeps inside us, and seldom awakens. The
> sleeper must awaken." -- Duke Leto Atreides
>
> _________________________________________________________________
> MSN 8 with e-mail virus protection service: 2 months FREE*
> http://join.msn.com/?page=features/virus
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Chris Berry
> INET: compjma_at_hotmail.com
>
> 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: ListGuru_at_fatcity.com (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: joan.hsieh_at_tufts.edu

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: ListGuru_at_fatcity.com (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).