In article <6rjfat$23i$1_at_storm.comstar.ru>, George Mikeladze
<gio_at_omega.ru> writes
>You can simply write an application (it could be a service or be started by
>service) that run in background, get the notification about system shutdown
>and shuts down oracle.
>
No you can't, I tried.
NT won't let you create a new thread or process once
the shutdown has started. Which means you can't invoke
shutdown immediate etc. Even if you pre-spawned svrmgr,
the connection would create a new thread in oracle80.exe,
and even if you pre-connected svrmgr then the db may be
bounced prior to the shutdown.
I believe oracle have an unpublished lib which you
could link to and thus safely perform the shutdown
in the same thread but... its not published.
In any case NT only allows you 20 secs to do something
before it kills all processes and this may not be
long enough to shutdown.
Feel free to correct me and I'll write the service.
Steve
--
"The floggings will continue until morale improves."
Received on Fri Aug 21 1998 - 12:24:27 CDT
