"alter database open" hangs spinning on the CPU patching the DB
Last updated on DECEMBER 15, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***
alter database open spins on the CPU with no end.
The database has been recently patched by Patch 20299012. This is the 22.214.171.124.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.
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