Re: Slow Database Shutdown Time

Same here, almost always shuts down :)  

sqlplus "/ as sysdba" <<EOF | tee -a $log whenever sqlerror exit failure
alter system checkpoint ;
shutdown abort ;
startup restrict ;
shutdown immediate ;
EOF >>> Vasu Balla <appsdba_at_gmail.com> 06/08/05 12:49 PM >>>

i usually do

alter system checkpoint;
shutdown abort
startup
shutdown immediate

sometimes i tend to forget checkpoint & abort and directly do shutdown immediate. in this case , atleast in 9.2.0.4+ , alert log will list PIDs of all active server process that shutdown is waiting on .so=20 just killing them will get the db down real fast

-vAsu

On 6/8/05, Dennis Williams <oracledba.williams_at_gmail.com> wrote:

> mentions, namely shutdown abort, followed by a startup and a normal
> shutdown. Some sites have had a normal shutdown immediate hang for
> extended periods of time. There were rumors that in earlier versions
> of Oracle there were some issues with shutdown abort, but recent
> Oracle versions don't seem to have that problem.
>=20
> Dennis Williams

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l