从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个节点均成功打完该补丁
文章评论