Re: Type of shutdown

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 18 Aug 2004 20:06:52 +1000
Message-ID: <41232a58$0$25948$afc38c87@news.optusnet.com.au>

Frank van Bortel wrote:

> marjina98_at_hotmail.com wrote:

>> Hello,
>>
>> Thanks for your information.
>>
>> With regards to shutdown the database via windows services, I like to
>> ask what is the purpose of the following registry
>> ORA_sid_SHUTDOWN_TIMEOUT (30)

> 
> 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