Re: Oracle7 on WinNT - shutdown?

The functionality is not available in Oracle. But...you can write a windows AT script to handle a graceful shutdown. I don't have a script for you but you can probably get one from Metalink or from doing a dejanews search of this forum.

Van

Pete Sharman <psharman_at_us.oracle.com> wrote in message news:3805FEF8.72C67B96_at_us.oracle.com...
> The functionality you describe is not available in Oracle7.
>
> The reason for the problem is that Microsoft only allows something like 20
> seconds to shutdown a service. In Oracle's case, if there are long
running
> transactions, the only way that time limit can be met is by doing a
shutdown
> abort, which forces instance recovery on startup.
>
> HTH.
>
> Pete
>
> Peter Laursen wrote:
>
> > K.Spiller <k.spiller_at_deutschepost.de> skrev i artiklen
> > <38058545.C6CEBC2D_at_deutschepost.de>...
> > > So anybody can give me a rough explanation
> > > how to set up an automatic shutdown process for my DB?
> > > (I'm still wondering why that Oracle instance manager isn't
> > > able to install something like that anyway).
> >
> > Hi Kathrin
> >
> > I have no experience with Oracle 7, but here is what I do with 8.0.5 on
NT:
> >
> > In the registry set HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ORA_SHUTDOWN to
TRUE
> > Then before the services stop, they will call
> > %ORACLEHOME%/database/orashut.bat with a temporary internal password,
only
> > valid for the duration of the shutdown.
> > Orashut.bat runs orashut.sql in svrmgr, which does a 'shutdown
immediate'
> >
> > Peter Laursen
>
Received on Thu Oct 14 1999 - 17:51:56 CDT