ORA-00600: Internal Error Code, Arguments: [kkogbro: No Kkoaptyp], [0]

(Doc ID 1674064.1)

Last updated on SEPTEMBER 11, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 08-May-2017***

Symptoms

- Different select statements are failing with:

ORA-00600: internal error code, arguments: [kkogbro: no kkoaptyp], [0], [], [], [], [], [], [], [], [], [], []

- The trace file shows the following information :

----- Current SQL Statement for this session (sql_id=4kg73387w25jw) -----
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x556335378      7486  package body APPS.WF_MAIL
0x54dd26410         1  anonymous block

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
kkogbro  kkojnp  kkocnp  kkooqb kkoqbc  apakkoqb  apaqbdDescendents  apaqbdList  apaqbdDescendents apaqbdList  apaqbd  apadrv  opitca  kksFullTypeCheck rpiswu2
kksLoadChild  kxsGetRuntimeLock  kksfbc  kkspbd0 kksParseCursor  opiosq0  opipls  opiodr  rpidrus  skgmstack  rpiswu2  rpidrv  psddr0  psdnal
...........
----- Session Cursor Dump -----
Current cursor: 22, pgadep=1

Open cursors(pls, sys, hwm, max): 22(1, 0, 64, 600)
NULL=0 SYNTAX=1 PARSE=0 BOUND=21 FETCH=0 ROW=0
Cached frame pages(total, free):
4k(16, 15), 8k(0, 0), 16k(2, 2), 32k(0, 0)
.....
----------------------------------------
Cursor#22(0x7f1d696e2800) state=SYNTAX curiob=0x7f1d6943ea88
curflg=cd fl2=0 par=(nil) ses=0x55ccdc648
----- Dump Cursor sql_id=4kg73387w25jw xsc=0x7f1d6943ea88 cur=0x7f1d696e2800 -----

LibraryHandle:  Address=0x5597f9620 Hash=fc1163c LockMode=N PinMode=0 LoadLockMode=0 Status=VALD
 ObjectName:  Name=SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2  
   FullHashValue=48a15e1a65019b78493ce31a0fc1163c Namespace=SQL AREA(00) Type=CURSOR(00) Identifier=264312380 OwnerIdn=590
...........
----- Current SQL Statement for this session (sql_id=4kg73387w25jw) -----
SELECT OVERRIDE_EMAIL_CHARSET FROM WF_LANGUAGES WHERE CODE ='WFCS' AND ROWNUM < 2
........
_optimizer_native_full_outer_join   = force
optimizer_outer_join_to_inner      = true
_optimizer_full_outer_join_to_outer = true
_first_k_rows_dynamic_proration     = true

 

 - The HashFullOuterJoin access path is enabled: _optimizer_native_full_outer_join   = force

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