drop table xxx ; 和 drop user xxx cascade 的时候,遇见 ORA-00600

在测试库 drop table xxx ; 和 drop user xxx cascade 的时候,遇见 ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0],

[oracle@mdcnprest trace]$ less /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/trace/CNP4T5_ora_1760.trc
Trace file /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/trace/CNP4T5_ora_1760.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1
System name: Linux
Node name: mdcnprest
Release: 2.6.32-431.el6.x86_64
Version: #1 SMP Fri Nov 22 03:15:09 UTC 2013
Machine: x86_64
VM name: VMWare Version: 6
Instance name: CNP4T5
Redo thread mounted by this instance: 1
Oracle process number: 21
Unix process pid: 1760, image: oracle@mdcnprest (TNS V1-V3)

*** 2019-01-28 23:02:35.441
*** SESSION ID:(69.9) 2019-01-28 23:02:35.441
*** CLIENT ID:() 2019-01-28 23:02:35.441
*** SERVICE NAME:(SYS$USERS) 2019-01-28 23:02:35.441
*** MODULE NAME:(SQL*Plus) 2019-01-28 23:02:35.441
*** ACTION NAME:() 2019-01-28 23:02:35.441

Incident 8573 created, dump file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8573/CNP4T5_ora_1760_i8573.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

*** 2019-01-28 23:04:15.032
Incident 8574 created, dump file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8574/CNP4T5_ora_1760_i8574.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

*** 2019-01-28 23:04:37.636
Incident 8575 created, dump file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8575/CNP4T5_ora_1760_i8575.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

*** 2019-01-28 23:05:15.741
Incident 8576 created, dump file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8576/CNP4T5_ora_1760_i8576.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

*** 2019-01-28 23:05:47.957
Incident 8577 created, dump file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8577/CNP4T5_ora_1760_i8577.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

*** 2019-01-28 23:07:10.904
DDE: Problem Key ‘ORA 600 [kntgMvLogObjn]’ was flood controlled (0x2) (incident: 8578)
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []
kgskupdbalance: time_used[36662344] greater than threshold[30000000] current_time[1548689227717712] time_start[1548689191055368]
[oracle@mdcnprest trace]$
[oracle@mdcnprest trace]$

[root@mdcnprest ~]# less /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8577/CNP4T5_ora_1760_i8577.trc
Dump file /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/incident/incdir_8577/CNP4T5_ora_1760_i8577.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
。。。

*** 2019-01-28 23:05:47.957
*** SESSION ID:(69.9) 2019-01-28 23:05:47.957
*** CLIENT ID:() 2019-01-28 23:05:47.957
*** SERVICE NAME:(SYS$USERS) 2019-01-28 23:05:47.957
*** MODULE NAME:(SQL*Plus) 2019-01-28 23:05:47.957
*** ACTION NAME:() 2019-01-28 23:05:47.957

Dump continued from file: /u01/app/oracle/diag/rdbms/cnp4t5/CNP4T5/trace/CNP4T5_ora_1760.trc
ORA-00600: internal error code, arguments: [kntgMvLogObjn], [0], [], [], [], [], [], [], [], [], [], []

========= Dump for incident 8577 (ORA 600 [kntgMvLogObjn]) ========

*** 2019-01-28 23:05:47.957
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=6d8dukb8vf0sc) -----
drop table ITMATT purge

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)


skdstdst()+41 call kgdsdst() 000000000 ? 000000000 ?

试了修改undo 表空间,仍然是同样的错误。
今天想起来,上次恢复测试库的时候更改过 username (schema) :
update user$ set name=‘SCOTT2’ where user#=84;
commit;

于是,今天把上次修改的 username 修改回去,然后再次尝试drop table :
P4PST1@CNP4T5> drop table itmatt ;

Table dropped.

P4PST1@CNP4T5>

  • 2
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值