ORA-600 [525] [0x653EF8048], [14],[resmgr:actses change group] (Doc ID 1990323.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.2.0.1 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

An INSERT /*+ append */ fails in an application log with next error details:

Running sqlplus for 'LOADCURRENTELEMENTSOUT 0004'
BEGIN LOADCURRENTELEMENTSOUT(2015073); END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "STOREDP.DYNAMICSQL", line 68
ORA-12801: error signaled in parallel query server P013, instance ok201pn:PIAD1
(1)
ORA-00600: internal error code, arguments: [525], [0x653EF8048], [14],
[resmgr:actses change group], [654], [0x653F1F148], [resmgr:actses change
state], [], [], [], [], []
ORA-06512: at "STOREDP.LOADCURRENTELEMENTSOUT", line 157
ORA-06512: at "STOREDP.LOADCURRENTELEMENTSOUT", line 216
ORA-06512: at line 1


The trace file as referenced in the alert log contains a call stack including next details:

 kgskswch()+247 call kgskglt() 00A010520 ? 653EF8048 ?
  000000001 ? 000000000 ?
  000000DA6 ? 000000000 ?
kgskexitsch()+143 call kgskswch() 00A010520 ? 648C3F750 ?
  000000001 ? 000000000 ?
  000000DA6 ? 000000000 ?
kgskflt()+167 call kgskexitsch() 00A010520 ? 648C3F750 ?
  000000DA6 ? 000000000 ?
  000000DA6 ? 000000000 ?
kgkpgcremovefrl()+5 call kgskflt() 00A010520 ? 658F4E400 ?
39 000000DA6 ? 648C3F750 ?
  648C3F800 ? 000000000 ?
kgskswch()+895 call kgkpgcremovefrl() 00A010520 ? 648C3F750 ?


Note that the call stack shows twice the function 'kgskswch'

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