ORA-600 [QESMAGETPAMR-NULLCTX]

2020年12月30日 718点热度 0人点赞 0条评论

从11g源数据库,用数据泵通过dblink方式不落地导入数据到19c,遭遇Bug# 30321076。
数据泵报错日志如下:

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 3 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 6 with process name "DW02" prematurely terminated
ORA-31671: Worker process DW02 had an unhandled exception.
Job "SYS"."IMPDP_202012292030" stopped due to fatal error at Tue Dec 29 23:41:33 2020 elapsed 0 03:08:44

数据库报错日志如下:

2020-12-29T23:40:38.766472+08:00
Errors in file /u01/app/oracle/diag/rdbms/wydb/wydb1/trace/wydb1_dw04_366112.trc  (incident=862366) (PDBNAME=PDBAPP):
ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx], [], [], [], [], [], [], [], [], [], [], []
PDBAPP(3):Incident details in: /u01/app/oracle/diag/rdbms/wydb/wydb1/incident/incdir_862366/wydb1_dw04_366112_i862366.trc
2020-12-29T23:40:39.785513+08:00
PDBAPP(3):Non critical error ORA-00602 caught while writing to trace file "/u01/app/oracle/diag/rdbms/wydb/wydb1/incident/incdir_862366/wydb1_dw04_366112_i862366.trc"
Error message: ORA-00602: internal programming exception: [PC:0x7F5612F60EF9] [ADDR:0x7F5600000001]
ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx], [], [], [], [], [], [], [], [], [], [], []

查询MOS关于"qesmaGetPamR-NullCtx"的bug和patch,得到Patch 30321076

The following are the bugs fixed by this patch:
  30321076: RTI 22224358 : ORA-600 [QESMAGETPAMR-NULLCTX],

下载打补丁,严格按照README文件操作,RAC集群两个节点、ADG节点逐一停服务、打补丁、启动数据库,大致输出如下。

■■节点1操作如下

[oracle@wydb01:1 /u01/soft/patch/30321076]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.21
Copyright (c) 2020, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.2.0/db_1/oraInst.loc
OPatch version    : 12.2.0.1.21
OUI version       : 12.2.0.7.0
Log file location : /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2020-12-30_13-22-51PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   30321076  

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/12.2.0/db_1')

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '30321076' to OH '/u01/app/oracle/product/12.2.0/db_1'

Patching component oracle.rdbms.rsf, 19.0.0.0.0...

Patching component oracle.rdbms, 19.0.0.0.0...
Patch 30321076 successfully applied.
Log file location: /u01/app/oracle/product/12.2.0/db_1/cfgtoollogs/opatch/opatch2020-12-30_13-22-51PM_1.log

OPatch succeeded.

■■节点1再次检查

[oracle@wydb01:1 /u01/soft/patch/30321076]$ $ORACLE_HOME/OPatch/opatch lsinv

Patch  30321076     : applied on Wed Dec 30 13:23:46 CST 2020
Unique Patch ID:  23791630
Patch description:  "RTI 22224358   ORA-600 [QESMAGETPAMR-NULLCTX],"
   Created on 5 Sep 2020, 19:15:35 hrs PST8PDT
   Bugs fixed:
     30321076
   This patch overlays patches:
     31771877, 29517242, 31281355, 31771877
   This patch needs patches:
     31771877, 29517242, 31281355, 31771877
   as prerequisites

■■节点2操作同节点1

■■adg节点在关闭相关进程时,需操作dgmgr的FSFO进程,如下

[oracle@wydbadg:1 ~]$ ps -ef|grep oracle
root      63276  63126  0 13:20 pts/1    00:00:00 su - oracle
oracle    63278  63276  0 13:20 pts/1    00:00:00 -bash
oracle    64921  63278  0 13:40 pts/1    00:00:00 ps -ef
oracle    64922  63278  0 13:40 pts/1    00:00:00 grep --color=auto oracle
oracle   119470      1  0 Nov28 ?        00:56:10 dgmgrl                      start observer file=FSFO.dat
[oracle@wydbadg:1 ~]$ kill 119470

■■最后3个节点均成功打完该补丁

liking

我是雪人

文章评论