KUP-600[Kudmcxgg:Grfunc] Seen On Dml Involving External Tables (Doc ID 741083.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6
This problem can occur on any platform.

Symptoms

The following symptoms are attributed to this issue :-

a) The DB version is >=V11106 on any supported platform
b) Alert log will show errors similar to :-

Errors in file /u01/app/oracle/diag/rdbms/xxxx/xxxx2/trace/xxxx2_ora_6698.trc
(incident=41997):
KUP-00600: internal error, arguments [kudmcxgg:grfunc] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/xxxx/xxxx2/incident/incdir_41997/xxxx2_ora_6698_i41997.trc

c) Within the trace file the 'Current SQL' will be shown :-

----- Current SQL Statement for this session (sql_id=2ft90rdbz3fuu) -----
INSERT INTO ... SELECT ... FROM EXTERNAL_TABLE

If the use of an 'External Table' is seen in the SQL then this note covers a possible
root cause.  However it does not have to be present in the SQL itself, if not seen
here the 'Explain Plan' section of the trace should be reviewed to see if present there.

The trace file can be searched for the string 'EXTERNAL TABLE', if there is no
mention at all of this then this note is unlikely to provide a resolution.

d) Stack trace will be similar to :-

Function List (to Full stack) (to Summary stack)
kgesinv <- kgesin <- kudmcxgg <- PGOSF2_kudmxo <- kpxsOpen <-
PGOSF299_qxxqOpen <- spefcpfa <- spefmccallstd <- pextproc

'KUDMCXGG' must be present in the stack for this note to be considered  to provide
a possible resolution

e) Within the trace file we may see evidence of ORACLE_LOADER in use :-

SO: 0xb2b1d4b0, type: 70, owner: 0xc2ba99a0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0xc2631f58, name=LIBRARY OBJECT LOCK, file=kgl.h LINE:7981, pg=0
LIBRARY OBJECT LOCK: 0xb2b1d4b0 handle=0xb2c379a0 mod=N
pnc=0xaa5c37d8 pns=(nil) cbb=1 rpr=1 exc=0 ilh=(nil) ctx=(nil)
use=0xc2ba99a0 ses=0xc2ba99a0 cnt=1 flg=PNC/[0002] spn=0x60b
LIBRARY HANDLE:0xb2c379a0 bid=120229 hid=1f7fd5a5 lmd=N pmd=S sta=VALD
name=SYS.ORACLE_LOADER

If in doubt as to whether or not these symptoms are being met or how to resolve via
this note please raise a SR to ORACLE Support.

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