ORA-00600 [KGHALO2] AND KUP-04050 Error While Running SELECT Statement

(Doc ID 1959633.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

When trying to query an external table the following error is raised on screen:

SQL> select count(*) from SCHEMA.TABLENAME;
select count(*) from SCHEMA.TABLENAME
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEFETCH callout
ORA-29400: data cartridge error
KUP-04050: error while attempting to allocate 67108864 bytes of memory
ORA-06512: at "SYS.ORACLE_LOADER", line 52

 

The following error is reported in the alert.log at the same time:

Alert Log : ORA-00600: internal error code, arguments: [KGHALO2], [0x0], [], [], [], [], [], []

 

Memory Chunk information from the trace file written by the ORA-600 [KGHALO2] is similar to that below:

+++
kghalo bad size 0x04000244
EXTENT 0 addr=0xfd687818
Chunk fd687820 sz=    67552    freeable  "Alloc environm "  ds=0xfd93bc60
Chunk fd8e3d64 sz=     1036    recreate  "kxs-heap-d     "  latch=(nil)
   ds fd858a74 sz=     1036 ct=        1
Chunk fd8e4170 sz=     1036    recreate  "kxs-heap-d     "  latch=(nil)
   ds fd88843c sz=     1036 ct=        1
Chunk fd8e457c sz=     1036    recreate  "kxs-heap-b     "  latch=(nil)
etc..

 

 

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