Database Hangs with ORA-7445 [kglic0()+1172], PMON Failed to Acquire Latch, ORA-29771
Last updated on MARCH 15, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Information in this document applies to any platform.
Next error is reported in the alert log:
The call stack from the trace file shows functions like:
In alert.log, also other errors are reported next to the ORA-7445 in the following order:
PMON failed to acquire latch, see PMON dump
LCK0 (ospid: 29766) waits for latch 'shared pool' for 92 secs.
ORA-29771: process USER (OSID 17702) blocks LCK0 (OSID 29766) for more than 70 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