ORA-600 [17128] , ORA-7445 Kghfrh_internal Or ORA-600 [KGHALO4] After Upgrade To 11.2.0.3 (Doc ID 1471032.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

You are encountering ORA-600 internal error [17128]

With event 10235 set to level 2, the error becomes ORA-7445 core dump [kghfrh_internal()+411]
sometimes followed by ORA-600 internal error [KGHALO4], [0x...], []

Stack trace is similar to:
... kghfrh_internal kghfrh kksCompileCallNotifier kscdnfy ksudlc kssdel ksupop kksPopCompileCall ...

Current SQL shows multiple views being accessed via in-line views:

 SELECT ... FROM (SELECT ... FROM (SELECT ...

or explicit use of ANSI JOIN keywords like LEFT OUTER JOIN

Changes

You recently upgraded your database from 10.2 to 11.2.0.3.0

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