Re: sqlplus shutdown "time-out"

From: <Rajesh.Rao_at_jpmchase.com>
Date: Tue, 19 Apr 2005 16:20:19 -0400
Message-ID: <OFE4842F47.1813A905-ON85256FE8.006F9F96@jpmchase.com>

It's documented in the alert log ;-)

Mon Apr 5 20:10:39 2004
Shutting down instance: further logons disabled Shutting down instance (immediate)
License high water mark = 51
Mon Apr 5 20:15:48 2004
Active call for process 15577 user 'oracle' program 'oracle_at_PRDEIS01 (TNS V1-V3)'
Active call for process 15601 user 'oracle' program 'oracle_at_PRDEIS01 (P019)'
SHUTDOWN: waiting for active calls to complete. Mon Apr 5 21:12:27 2004
SHUTDOWN: Active sessions prevent database close operation Tue Apr 6 03:39:42 2004
Starting ORACLE instance (normal)
Tue Apr 6 08:45:00 2004
Thread 1 advanced to log sequence 4636

Regards
Raj

                                                                                                                                        
                      Mladen Gogala                                                                                                     
                      <gogala_at_sbcglobal.        To:       kaygopal_at_gmail.com                                                            
                      net>                      cc:       vitalisman_at_gmail.com, Oracle-L <oracle-l_at_freelists.org>                       
                      Sent by:                  Subject:  Re: sqlplus shutdown "time-out"                                               
                      oracle-l-bounce_at_fr                                                                                                
                      eelists.org                                                                                                       
                                                                                                                                        
                                                                                                                                        
                      04/19/2005 01:38                                                                                                  
                      PM                                                                                                                
                      Please respond to                                                                                                 
                      gogala

Comments inline:

On 04/19/2005 12:53:20 PM, K Gopalakrishnan wrote:

> There is a timeout for shutdown (I think starting from 9iR2) which
> defaults to 60 minus. If the active calls (!) don't complete in that
> time, the instance just updates the alertlog and doesn;t shutdown its
> own. You need to shutdown abort.

Gopal, this is very interesting, thanks for sharing! Why do I need to abort=
? Would=20
"immediate" help? Is it controllable? Can it be seen anywhere?

>=20

> It is not documented btw :D

>=20

> ___
> Best Regards,
> K Gopalakrishnan=3D20
> Co-Author: Oracle Wait Interface, Oracle Press 2004
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
> --
> http://www.freelists.org/webpage/oracle-l
>=20
>=20

--=20
Mladen Gogala
Oracle DBA

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



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

Received on Tue Apr 19 2005 - 16:24:37 CDT