My Oracle Support Banner

ORA-00600 [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number] (Doc ID 2848323.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Oracle Server 19.x
Database has been recently upgraded/migrated or a Release Update (RU) has been applied/rolled back

 

There are different scenarios where this can be reported. Details below.

 

1> Errors while executing Datapump Export or Datapump Import.

Executing impdp or expdp from the prompt, returns errors as below (no log generated):

$ expdp <user>/<passwd> directory=<dir> dumpfile=<filename> <other options>      

Export: Release 19.0.0.0.0 - Production on Tue Feb 22 23:13:01 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

 

OR

 

$ impdp <user>/<passwd> directory=<dir> dumpfile=<filename> <other options>

Import: Release 19.0.0.0.0 - Production on Tue Feb 22 23:12:04 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

 

Return following:

 

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4747
ORA-06512: at "SYS.KUPV$FT_INT", line 2144
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.KUPV$FT_INT", line 2081
ORA-06512: at "SYS.DBMS_DATAPUMP", line 2263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4496
ORA-06512: at "SYS.DBMS_DATAPUMP", line 6127
ORA-06512: at line 1

The alert.log shows:

2022-02-17T17:54:21.467459-07:00
Errors in file <path>/app/oracle/diag/rdbms/<sid>/<SID>/trace/<SID>_ora_8262.trc (incident=276923):
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []
Incident details in: <path>/app/oracle/diag/rdbms/<sid>/<SID>/incident/incdir_276923/<SID>_ora_8262_i276923.trc

 

The incident trace file shows:

Dump continued from file: <path>/app/oracle/diag/rdbms/<sid>/<SID>/trace/<SID>_ora_8262.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number], [], [], [], [], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 276923 (ORA 600 [kwqintExeStmt: bind string failure]) ========

*** 2022-02-17T17:54:21.506463-07:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=annjna5zfzyhd) -----
DECLARE JOBHNDL NUMBER; BEGIN :JOBHNDL := SYS.DBMS_DATAPUMP.OPEN( operation =>:OPERATION, job_mode => :JOB_MODE, remote_link => :REMOTE_LINK, job_name => :JOB_NAME, version => :VERSION, ena_sec_roles => :ENASECRLS); END;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x8ee6fc20 135 package body SYS.DBMS_AQADM_SYS.AQ_INTERNAL_EXESTMT
0x8ee6fc20 227 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMT_IN_KERNEL_CURSOR
0x8ee6fc20 286 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMTCUSR
0x8ee6fc20 3074 package body SYS.DBMS_AQADM_SYS.CREATE_TABLE
0x8ee6fc20 3801 package body SYS.DBMS_AQADM_SYS.I_CREATE_QT
0x8ee6fc20 3469 package body SYS.DBMS_AQADM_SYS.CREATE_QUEUE_TABLE_INT
0x8ee87270 406 package body

.

.
 

 

 

2> Errors while attempting to create a queue table.

SQL> begin
2 dbms_aqadm.create_queue_table (
3 queue_table => '<OWNER>.<QUEUE_TABLE>',
4 multiple_consumers => TRUE,
5 queue_payload_type => '<OWNER>.<TYPE>');
6 end;
7 /
begin
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string
failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 135
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 227
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 286
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3074
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3801
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3469
ORA-06512: at "SYS.DBMS_AQADM", line 406
ORA-06512: at line 2

 

The incident trace file shows:

Dump continued from file: <path>/app/oracle/diag/rdbms/<sid>/<SID>/trace/<SID>_ora_12004.trc
[TOC00001]
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure],
[1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 153908 (ORA 600) ========

*** 2022-02-22T22:11:26.758871+00:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=3p8xkt6tb2xpf) -----
begin
dbms_aqadm.create_queue_table (
queue_table => '<OWNER>.<QUEUE_TABLE>',
multiple_consumers => TRUE,
queue_payload_type => '<OWNER>.<TYPE>');
end;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x698b0bc0 135 package body SYS.DBMS_AQADM_SYS.AQ_INTERNAL_EXESTMT
0x698b0bc0 227 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMT_IN_KERNEL_CURSOR
0x698b0bc0 286 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMTCUSR
0x698b0bc0 3074 package body SYS.DBMS_AQADM_SYS.CREATE_TABLE
0x698b0bc0 3801 package body SYS.DBMS_AQADM_SYS.I_CREATE_QT
0x698b0bc0 3469 package body SYS.DBMS_AQADM_SYS.CREATE_QUEUE_TABLE_INT
0x647d2e08 406 package body SYS.DBMS_AQADM.CREATE_QUEUE_TABLE

.

.

 

 

3> The Event Monitor process (qXXX) generates traces with the error.

The alert.log shows:

2022-02-17T19:16:03.920050-07:00
Errors in file <path>/app/oracle/diag/rdbms/<sid>/<SID>/trace/<SID>_q002_10549.trc (incident=276987):
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []
Incident details in: <path>/app/oracle/diag/rdbms/<sid>/<SID>/incident/incdir_276987/<SID>_q002_10549_i276987.trc

 

The incident trace file shows:

Dump continued from file: <path>/app/oracle/diag/rdbms/<sid>/<SID>/trace/<SID>_q002_10549.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kwqintExeStmt: bind string failure], [1036], [ORA-01036: illegal variable name/number
], [], [], [], [], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 276987 (ORA 600 [kwqintExeStmt: bind string failure]) ========

*** 2022-02-17T19:16:03.949346-07:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=7t57p8nrqhph2) -----
BEGIN sys.dbms_aqadm_sys.create_plsql_notif_queue_int(:1); END;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x8ee6fc20 135 package body SYS.DBMS_AQADM_SYS.AQ_INTERNAL_EXESTMT
0x8ee6fc20 227 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMT_IN_KERNEL_CURSOR
0x8ee6fc20 286 package body SYS.DBMS_AQADM_SYS.EXECUTE_STMTCUSR
0x8ee6fc20 3074 package body SYS.DBMS_AQADM_SYS.CREATE_TABLE
0x8ee6fc20 3801 package body SYS.DBMS_AQADM_SYS.I_CREATE_QT
0x8ee6fc20 3469 package body SYS.DBMS_AQADM_SYS.CREATE_QUEUE_TABLE_INT
0x8ee87270 406 package body SYS.DBMS_AQADM.CREATE_QUEUE_TABLE

.

.

 

 

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
 1> Errors while executing Datapump Export or Datapump Import.
 2> Errors while attempting to create a queue table.
 3> The Event Monitor process (qXXX) generates traces with the error.
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.