My Oracle Support Banner

Grid Infrastructure on Windows: Database Instance Takes A Very Long Time (25 minutes) to Start Up (Doc ID 2521146.1)

Last updated on MARCH 22, 2019

Applies to:

Oracle Database - Standard Edition - Version 12.2.0.1 and later
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

In a Grid Infrastructure managed environment (either Grid Infrastructure Standalone a.k.a. Oracle Restart OR Clustered Grid Infrastructure) on Windows, starting a database instance resource takes a very long amount of time (such as 25 minutes).

Further investigation determines that starting Oracle High Availability Services Daemon (OHASD) takes just 1 minute

and starting ASM (ora.asm) also takes just 1 minute, but starting the database instance(s) takes approximately 25 minutes to start.

The Grid Infrastructure alert.log file shows messages such as the following:



After multiple attempts, OHASD brings up the database instance but the start up time is increased to 25 minutes or even longer.

Changes

 In this case, the issue was observed after a Windows patch was applied and the server was rebooted.

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
References


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