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

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 .

问题定位完毕！