Re: Auto Shutdown on NT

Droth16842 wrote:

> Is there a way to get Oracle to shutdown cleanly when NT is
> shutdown?
> David J Roth
> droth_at_adaptron.com
> My opinions only

It is possible to setup an alert under NT to anticipate when a system resource reaches a specified threshold. The alerts facility under perfmon allows you to specify a program to run when a resource has exceeded the alert threshold.

For instance, you could set a threshold for the number of server system errors encountered (these indicate there is a problems with the server) etc. Such an alert could fire of a batch file to bring down the Oracle instance cleanly.
A batch file containing the command line parameters to the oradim7x.exe program might work.

This is the idea behind SNMP configured networks, in that a Management Console responds to alerts received from SNMP agents running on network clients. The basic idea behind Enterprise Manager I believe!.

You can also configure system properties (under Settings) for Recovery such that an administrative alert is issued when a STOP error is encountered. This would notify a user that the system should be shutdown.

Presumably, you wish to shutdown the database in order to perform a checkpoint etc. rather than what is effectively a "shutdown abort" when the instance service threads are stopped. I am not aware of any way to configure a service to shutdown other than by manual or by issuing net stop "service" command from a batch file.

It is probable worthwhile cross-posting this one to one of the NT newsgroups.

Hope this is of some help!

David Williams
david.williams_at_cit.act.edu.au
These opinions are my own Received on Tue Apr 29 1997 - 00:00:00 CDT