"alter database open" hangs spinning on the CPU patching the DB (Doc ID 2048632.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.4 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***

Symptoms

alter database open spins on the CPU with no end.

The database has been recently patched by Patch 20299012. This is the 11.1.0.7.23 Patch Set Update (includes CPUAPR2015).

The top call stack function of the process trying to open the database was:

 System state dumps shows that that process has been on the CPU since at least 97 min 26 seconds.

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