Database Hung On Shutdown After ORA-600 [KGHFRE3] Error (Doc ID 1135453.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jan-2014***

Symptoms

ORA-600 [KGHFRE3] error reported during shutdown and sessions cannot connect to the database, e.g.:

Fri Jun 25 17:23:28 2010
Completed: ALTER DATABASE OPEN
Shutting down instance: further logons disabled
Fri Jun 25 17:23:28 2010
Stopping background process QMNC
Fri Jun 25 17:23:29 2010
Stopping background process MMNL
Fri Jun 25 17:23:30 2010
Stopping background process MMON
Fri Jun 25 17:23:31 2010
Shutting down instance (immediate)
License high water mark = 6
Fri Jun 25 17:23:31 2010
Errors in file /opt/oracle/admin/ZTWMS/udump/ztwms_ora_16488.trc:
ORA-00600: internal error code, arguments: [KGHFRE3], [0xC00000001F75D078], [], [], [], [], [], []


The instance background processes still shown as present in 'ps -ef' output.

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