Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Type of shutdown
Frank van Bortel wrote:
> marjina98_at_hotmail.com wrote:
> > ORA_SID_SHUTDOWN_TIMEOUT: > sets the maximum time to wait before the service > for a particular SID stops. > Also: Sets the maximum time to wait for the shutdown to complete > before the service for a particular SID stops. > (Getting started Manual, ch. 10, and appendix C)
Yeah, that's what the documentation says.
Interesting little experiment though: set the TIMEOUT to, say, 5. Set the shutdown type to 'n' for normal. Reboot the machine to make the changes take effect. Log in a user to the database, and leave him logged in. Then try to stop the service.
The logged in user should prevent the shutdown normal taking place. But the TIMEOUT setting should, I would have thought, cause the service to stop regardless after X seconds.
Well, on my Windows 2000 + Oracle 8.1.7 set up, the service never shut down.
Just thought I'd mention it.
Regards
HJR
Received on Wed Aug 18 2004 - 05:06:52 CDT