ORA-00600 [17182] orORA-00600 [17147]错误处理分析过程

xxxx40-node1 ORA-600错误。
告警日志如下

/ORA-600
diagnosis.
It is recommended that you retain all the redo logs generated (by
all the instances) during the past 12 hours, in case additional
redo dumps are required to help with the diagnosis.
*****************************************************************
Errors in file /oracle/diag/rdbms/xxxx40/xxxx401/trace/xxxx401_ora_308282.trc (incident=518578):
ORA-00600: ，. : [17182], [0x7FFFF1CE8F20], [], [], [], [], [], [], [], [], [], []
ORA-00600: , . : [17147], [0x7FFFF1CE8F20], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/xxxx40/xxxx401/incident/incdir_518578/xxxx401_ora_308282_i518578.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.

Dumping diagnostic data in directory=[cdmp_20210801175050], requested by (instance=1, osid=308282), summary=[incident=518577].

针对600错误因为这个报错之前没有其他报错，我们初步认为是bug，我们先查看该库的RU以及bug列表。
[oracle@n-pc-sr850-306 ~]$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.
[oracle@n-pc-sr850-306 ~]$opatch lsinventory

......
27994325, 27997875, 27998003, 28000269, 28033429, 28040776, 28074713
28090453, 28099662, 28140658, 28171079, 28174827, 28184554, 28188330
28218832, 28226179, 28290434, 28305001, 28320399, 28354603, 28437315
28454242, 28508557, 28522441

而后从MOS上查到如下Doc
ORA-00600 [17182] orORA-00600 [17147] During Session Logoff (Doc ID 2598066.1)
从文中分析知道该bug涉及数据库包括如下范围，我们库是12.2.0.1（RU为12.2.0.1.181016）
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.6.0.0.0 [Release 12.1 to 19]

解决方式如下
Bug 28260171 - ORA-00600 [17182][17147] noticed during session logoff on 12.2.1
which is closed as a duplicate of Bug:28276054 ORA-00600:[KGHRCDEPTH:DS] AND [17163] REPORTED IN 12.2
解决方式
升级到202004 （DB RU）
或者
下载和应用interim Patch 28276054。

我们下载了interim Patch 28276054，通过readme知道这bug是支持rolling patch的，我们看看整个过程。
1 解压：
$ unzip -d <PATCH_TOP_DIR> p28276054_122010_Linux-x86-64.zip
2 冲突检查：
$ cd <PATCH_TOP_DIR>/28276054
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
3 关闭集群和数据库以及其他涉及oracle_home得服务
4 打补丁
$ cd <PATCH_TOP_DIR>/28276054

$ opatch apply -local

5 验证是否安装成功
$ opatch lsinventory
6 启动集群和数据库

如果需要回退
1 关闭涉及Oracle home的所有服务
2 回退
$ opatch rollback -id 28276054
3 启动集群和数据库
4 验证是否删除
$ opatch lsinventory

总结： 对于Oracle而言定期升级RU可以有效避免bug的出现，保持系统文档安全运行。对于滚动升级而言对业务基本没有影响。