ORA-00600 [KGHALO2] AND KUP-04050 Error While Running SELECT Statement
(Doc ID 1959633.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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
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..
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
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 |
| Cause |
| Solution |
| References |