My Oracle Support Banner

设置10046/10053事件发生ORA-600 [dbgdrebuildScope_Scope_Missing]错误 (Doc ID 2577520.1)

Last updated on AUGUST 21, 2019

适用于:

Oracle Database - Enterprise Edition - 版本 12.2.0.1 到 12.2.0.1 [发行版 12.2]
Oracle Database - Standard Edition - 版本 12.2.0.1 到 12.2.0.1 [发行版 12.2]
本文档所含信息适用于所有平台

症状

在多个会话中为特定SQL语句设置10046/10053事件时,例如:

alter system set events 'sql_trace[sql:<SQL_ID>] level=12';

发生下面的错误:

ORA-00600: internal error code, arguments: [dbgdrebuildScope_Scope_Missing], [0x12ED5B130], [], [], [], [], [], [], [], [], [], []

 

测试用例:

[...]$ sqlplus / as sysdba
...

SQL> create tablespace t1 datafile 't1.dbf' size 500M segment space management auto;

Tablespace created.

SQL> connect t1/t1
Connected.
SQL> create table t1 (c1 number);

Table created.

SQL> insert into t1 values (1);

1 row created.

SQL> commit;

Commit complete.

SQL> select /* user1 */ * from t1;

        C1
----------
         1

SQL> select sql_id from v$sql where sql_text like '%user1%';

SQL_ID
-------------
1zbtxw8wr1ft1
b22b2yh1xabbj
cj738u935gtyw

SQL> connect / as sysdba
Connected.
SQL> alter system set events 'sql_trace[sql:b22b2yh1xabbj] level=12';

System altered.

SQL> exit

...
[...]$ sqlplus / as sysdba
...

SQL> alter system set events 'sql_trace[sql:b22b2yh1xabbj] level=12';

System altered.

SQL> exit

...
[...]$ sqlplus / as sysdba
...

SQL> alter system set events 'sql_trace[sql:b22b2yh1xabbj] level=12';

System altered.

SQL> alter system set events 'sql_trace[sql:cj738u935gtyw] level=12';

System altered.

SQL> exit

...
[...]$ sqlplus / as sysdba
...

SQL> alter system set events 'sql_trace[sql:cj738u935gtyw] level=12';
alter system set events 'sql_trace[sql:cj738u935gtyw] level=12'
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [dbgdrebuildScope_Scope_Missing],
[0x067CC01E0], [], [], [], [], [], [], [], [], [], []

SQL>

 

相关事件跟踪文件中的调用堆栈显示:

ksedst <- dbkedDefDump <- ksedmp <- dbgexPhaseII <- dbgexProcessError
 <- dbgePostErrorKGE <- 1767 <- dbkePostKGE_kgsf <- kgeadse <- kgerinv_internal
  <- kgerinv <- kgeasnmierr <- dbgdRebuildScope <- 827 <- dbgdParseCmd
   <- dbkdParseCmd <- kkyasy_options <- 896 <- kkyasy <- kksExecuteCommand
    <- opiexe <- kpoal8 <- opiodr <- ttcpip <- opitsk
     <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
      <- ssthrdmain <- main <- libc_start_main <- start

 

更改

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.