Database Does Not Shutdown Cleanly When Oracle Service Is Restarted (Doc ID 437876.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 9.2.0.1 and later
Generic Windows
***Checked for relevance on 25-Apr-2012***

Symptoms

When the Oracle service is restarted, there is no information about a database shutdown.
However, there is an entry in the alert log for a subsequent database startup.

ORA_SID_AUTOSTART and ORA_SID_SHUTDOWN registry settings are set to TRUE.

Eg:

C:\> NET STOP "OracleServiceAPU01"
The OracleServiceAPU01 service is stopping....
The OracleServiceAPU01 service was stopped successfully.


C:\>time /t
10:33

Alert Log shows:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms