Re: Automatic Oracle shutdown on NT?

My understanding is that all NT services are only given a small window of like 4 seconds to terminate itself, thus Oracle only has time enough to do a shutdown abort -- which would require an instance recovery I believe.

A design flaw/feature in services.

-Doug  

Adrian Shepherd <Adrian.Shepherd_at_BTINTERNET.COM> wrote:
: Am I missing something here or doesn't oradimXX have a -shutmode
: and -shuttype parameter ?
 

: If not then I had better revisit the shutdown procedures on my machine. I
: was under the impression that -shuttype was initiated to send a -shutmode to
: the database service, and all was OK.

: Clay Davidson wrote in message <34a4988f.4992258_at_news.his.com>...
: >What version of Oracle?
: >In the 7.x series, you have to shut down the database before you
: >shutdown the service. Shutting down the service first is sort of like
: >a shutdown abort.
: >
: >In Oracle 8, they added some stuff to services to call a batch file
: >(basically) and shutdown the database when the service shutsdown.
: >
: >You can do the same thing by writing a command file and calling it
: >before you shutdown.
: >
: >Would not suggest just shutting down the NT Server before making sure
: >your database (which is probably why you have the NT box in the first
: >place) is gracefully exited.
: >
: >Just my 2 cents worth.
: >
: >
: >
: >On 22 Dec 1997 00:26:47 GMT, Bill Canning
: ><bill.canning_at_SanDiegoCA.NCR.COM> wrote:
: >
: >>Has anyone solved the problem of Oracle shutting down automatically when
: >>NT is shutdown?
: >>
: >>My Oracle instances startup automatically under NT, but a check
: >>of the alert
: >>log shows they are crashing on NT shutdown and needing instance recovery
: >>on startup.
: >>
: >>On further investigation, I find that shutting down the service
: >>manually from
: >>the Services menu is also not enough. The alert log indicates
: >>the instance is
: >>not actually stopped.
: >>
: >>Manual shutdown using oradim73 or svrmgr23 works correctly.
: >>
: >
Received on Tue Dec 30 1997 - 00:00:00 CST