Re: Oracle7 on WinNT - shutdown?

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 - 11:04:09 CDT