My Oracle Support Banner

RAC ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2] doing CTAS (Doc ID 2148088.1)

Last updated on JANUARY 16, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.

Symptoms

When executing a "create table as select " on a 3 node cluster we receive:
ERROR at line 2:
ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2],
[0x7FC75670F000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kghstack_underflow_internal_2],
[0x7FC75670F000], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [ktagetg can't be used for a DDL.
Use ktagetg_ddl ], [], [], [], [], [], [], [], [], [], [], []

We only receive this on 1 node (<DB_NAME2>), CTAS succeeds on <DB_NAME1> and <DB_NAME3>
Additional info:
We are in the middle of an OS patching cycle
<DB_NAME1> - not patched (CTAS succeeds)
<DB_NAME2> - patched (CTAS fails)
<DB_NAME3> - patched (CTAS succeeds)



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.