ORA-00600:[k2gteget: Pdbid] (Doc ID 2065740.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Getting:

ORA-00600: internal error code, arguments: [k2gteget: pdbid], [14], [1], [], [], [], [], [], [], [], [], []
ORA-13639: The current operation was interrupted because it timed out.

The trace file would show :

*** MODULE NAME:(DBMS_SCHEDULER) 2015-09-09 01:20:29.929
*** CLIENT DRIVER:() 2015-09-09 01:20:29.929
*** ACTION NAME:(ORA$AT_SQ_SQL_SW_265) 2015-09-09 01:20:29.929
*** CONTAINER ID:(1) 2015-09-09 01:20:29.929

[TOC00000]
Jump to table of contents
Dump continued from file: /opt/oracle/base/diag/rdbms/con1np/CON1NP_2/trace/CON1NP_2_j033_13315.trc
[TOC00001]
ORA-00600: internal error code, arguments: [k2gteget: pdbid], [14], [1], [], [], [], [], [], [], [], [], []
ORA-13639: The current operation was interrupted because it timed out.
.
.
*** 2015-09-09 01:20:29.930
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=cnphq355f5rah) -----
DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(30) := :job_name;  job_subname VARCHAR2(30) := :job_subname;  job_owner VARCHAR2(30) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  chain_id VARCHAR2(14) :=  :chainid;  credential_owner varchar2(30) := :credown;  credential_name  varchar2(30) := :crednam;  destination_owner varchar2(30) := :destown;  destination_name varchar2(30) := :destnam;  job_dest_id varchar2(14) := :jdestid;  log_id number := :log_id;  BEGIN  DECLARE
        ename             VARCHAR2(30);
        exec_task         BOOLEAN;
      BEGIN
        -- check if tuning pack is enabled
        exec_task := prvt_advisor.is_pack_enabled(
                       dbms_management_packs.TUNING_PACK);
        -- check if we are in a pdb,
        -- since auto sqltune is not run in a pdb
        IF (exec_task AND -- tuning pack enabled
        sys_context('userenv', 'con_id') <> 0 AND -- not in non-cdb
        sys_context('userenv', 'con_id') <> 1  ) THEN -- not in root
          exec_task := FALSE;
        END IF;
        -- execute auto sql tuning task
        IF (exec_task) THEN
          ename := dbms_sqltune.execute_tuning_task(
                     'SYS_AUTO_SQL_TUNING_TASK');
        END IF;
        -- check whether we are in non-CDB or a PDB
        -- auto SPM evolve only runs in a non-CDB or a PDB, not the root.
        IF (sys_context('userenv', 'con_id') = 0 OR
            sys_context('userenv', 'con_id') > 2) THEN
          exec_task := TRUE;
        ELSE
          exec_task := FALSE;
        END IF;
        -- execute auto SPM evolve task
        IF (exec_task) THEN
          ename := dbms_spm.execute_evolve_task('SYS_AUTO_SPM_EVOLVE_TASK');
        END IF;
      END;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x7718235c8     12825  package body SYS.DBMS_SQLTUNE_INTERNAL
0xb69266a8         7  SYS.WRI$_ADV_SQLTUNE
0xb33fab58       602  package body SYS.PRVT_ADVISOR
0xb33fab58      2678  package body SYS.PRVT_ADVISOR
0x786f1e420       241  package body SYS.DBMS_ADVISOR
0x786f168e8       937  package body SYS.DBMS_SQLTUNE
0xddc82928        19  anonymous block
[TOC00004-END]
[TOC00003-END

.

.

qksanAnalyzeSql  qksanAnalyzeSegSql  kestseDoOneExec  kestseDoOneRound  kestsePlansDoRounds  kestseExecutePlans  kestsaTestPlans  kestsaAutoTuneDrv  kestsTuneSqlDrv  kesaiExecAction  kesaiTuneSqlDrv...

.

.

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