Re: sqlplus shutdown "time-out"
- From: Rajesh.Rao@xxxxxxxxxxxx
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 19 Apr 2005 16:20:19 -0400
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@PRDEIS01 (TNS
V1-V3)'
Active call for process 15601 user 'oracle' program 'oracle@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@sbcglobal. To: kaygopal@xxxxxxxxx
net> cc: vitalisman@xxxxxxxxx,
Oracle-L <oracle-l@xxxxxxxxxxxxx>
Sent by: Subject: Re: sqlplus shutdown
"time-out"
oracle-l-bounce@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/
> --
> //www.freelists.org/webpage/oracle-l
>=20
>=20
--=20
Mladen Gogala
Oracle DBA
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
