My Oracle Support Banner

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

Last updated on AUGUST 09, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Generic Windows

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:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.