ITPub博客

首页 > 数据库 > > move表导致ORA-600错误案例分析

move表导致ORA-600错误案例分析

作者:Abraham林老师 时间:2020-08-19 11:04:13 0 删除 编辑

TM30-NODE3多个ORA-00600报错
2020-08-18T10:43:14.385944+08:00
Errors in file /oracle/diag/rdbms/tm30/tm303/trace/tj303_ora_263655.trc (incident=153752):
ORA-00600: internal error code, arguments: [kglLockGranted-illegal], [0x0EE863D10], [3], [2], [0x0EE863E78], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/tm30/tm303/incident/incdir_153752/tm303_ora_263655_i153752.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-08-18T10:43:15.640830+08:00
Dumping diagnostic data in directory=[cdmp_20200818104315], requested by (instance=3, osid=263655), summary=[incident=153752].
分析过程:
从incident details跟踪文件获得如下信息

[TOC00000]
Jump to table of contents
Dump continued from file: /oracle/diag/rdbms/tm30/tm303/trace/tj303_ora_263655.trc
[TOC00001]
ORA-00600: internal error code, arguments: [kglLockGranted-illegal], [0x0EE863D10], [3], [2], [0x0EE863E78], [], <<<<600详细信息
[], [], [], [], [], []

[TOC00001-END]
[TOC00002]
========= Dump for incident 153752 (ORA 600 [kglLockGranted-illegal]) ========
.....
client details:
O/S info: user: oracle, term: pts/2, ospid: 247674
machine: n-pc1 program: sqlplus@n-pc1 (TNS V1-V3)
application name: sqlplus@n-pc1 (TNS V1-V3), hash value=858467996
current SQL:
alter table FCCR.SYS_COMPANY_RELATION_FA move tablespace FCCR online <<<<<<<<<<<<<<<用户当前执行的SQL
也就是用户在执行表移动时,当时的运行环境触发了ORA-00600错误,我们知道600是一引擎错误,我们有理由怀疑是不是Oracle的bug

我们查询当前数据库的补丁集
oracle@n-pc1:[/oracle/12.2/OPatch]./opatch lspatches
;28111583;
28440725;OJVM RELEASE UPDATE: 12.2.0.1.181016 (28440725)
28662626;OCW OCT 2018 RELEASE UPDATE 12.2.0.1.181016 (28662626)
28662603;Database Oct 2018 Release Update : 12.2.0.1.181016 (28662603)

OPatch succeeded.

下面就需要到MOS找找看,是不是有对应Doc,12C运行了那么久很可能别人已经发现这个问题,于是,我搜索
ORA-00600: internal error code, arguments: [kglLockGranted-illegal] alter table 找到Doc ID 2478444.1
ORA-600[kglLockGranted-illegal] After ALTER TABLE ...MOVE ONLINE UPDATE INDEXES确认这是一个unpublished bug .

问题定位完毕!


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31540773/viewspace-3146884/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2018-07-18

  • 博文量
    169
  • 访问量
    1544