首页 » Cloud, ORACLE 9i-23ai » Alert: 升级19C(19.6) impdp导入分区表使用network_link时ORA-39029 ORA-31671 ORA-00600 [qesmaGetPamR-NullCtx]

Alert: 升级19C(19.6) impdp导入分区表使用network_link时ORA-39029 ORA-31671 ORA-00600 [qesmaGetPamR-NullCtx]

升级oracle 19c的计划基本都已提上日程,数据泵也是一种对于小型数据库常用的解决方案,但是还是有个bug在那悄悄等着,对于本地没有存放dumpfile存储空间时常常使用network_link“不落地式”的导入方式, 这里记录一个同步时遇到ORA-39014、ORA-39029、ORA-31671案例。

源 11.2.0.4, 目标19.6

$ impdp system/xxxxxx@xxxxxxx network_link=to_anbob directory=PUMP_DIR schemas='X','Y','Z' parallel=4 logfile=impdp_anbob_20200427.log EXCLUDE=STATISTICS cluster=N

Import: Release 19.0.0.0.0 - Production on Mon Apr 27 14:39:59 2020
Version 19.6.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/********@xxxxxxx network_link=to_anbob directory=PUMP_DIR schemas=X,Y,Z parallel=4 logfile=impdp_anbob_20200427.log EXCLUDE=STATISTICS cluster=N 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 355.5 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 4 with process name "DW03" prematurely terminated
ORA-31671: Worker process DW03 had an unhandled exception.

ORA-39029: worker 2 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 5 with process name "DW03" prematurely terminated
ORA-31671: Worker process DW03 had an unhandled exception.

ORA-39029: worker 6 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.

Job "SYSTEM"."SYS_IMPORT_SCHEMA_01" stopped due to fatal error at Mon Apr 27 14:41:33 2020 elapsed 0 00:01:30

Check Datapump process trace

$ cat anbob1_dw03_137773.trc
Trace file /u02/app/oracle/diag/rdbms/anbob/anbob1/trace/anbob1_dw03_137773.trc
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.6.0.0.0
Build label:    RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417
ORACLE_HOME:    /u02/app/oracle/product/19.0.0/db_1
System name:    Linux
Node name:      bdqsdb8
Release:        3.10.0-862.el7.x86_64
Version:        #1 SMP Wed Mar 21 18:14:51 EDT 2018
Machine:        x86_64
Instance name: anbob1
Redo thread mounted by this instance: 1
Oracle process number: 559
Unix process pid: 137773, image: oracle@xxxsdb8 (DW03)


*** 2020-04-27T14:41:06.258595+08:00
*** SESSION ID:(3797.47194) 2020-04-27T14:41:06.258612+08:00
*** CLIENT ID:() 2020-04-27T14:41:06.258617+08:00
*** SERVICE NAME:(anbob) 2020-04-27T14:41:06.258621+08:00
*** MODULE NAME:(Data Pump Worker) 2020-04-27T14:41:06.258626+08:00
*** ACTION NAME:(SYS_IMPORT_SCHEMA_01) 2020-04-27T14:41:06.258630+08:00
*** CLIENT DRIVER:() 2020-04-27T14:41:06.258634+08:00
*** CONTAINER ID:(5) 2020-04-27T14:41:06.258639+08:00
 
2020-04-27T14:41:06.258398+08:00
Incident 404475 created, dump file: /u02/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_404475/anbob1_dw03_137773_i404475.trc
ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx], [], [], [], [], [], [], [], [], [], [], []


*** 2020-04-27T14:41:10.190015+08:00
2020-04-27T14:41:10.190003+08:00
Incident 404476 created, dump file: /u02/app/oracle/diag/rdbms/anbob/anbob1/incident/incdir_404476/anbob1_dw03_137773_i404476.trc
ORA-00600: internal error code, arguments: [qesmaGetPamR-NullCtx], [], [], [], [], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "SYS.KUPD$DATA", line 1308
ORA-06512: at "SYS.KUPD$DATA", line 1400
ORA-06512: at "SYS.KUPD$DATA", line 3815
ORA-06512: at "SYS.KUPD$DATA", line 4149
ORA-06512: at "SYS.KUPD$DATA", line 6024
ORA-06512: at "SYS.KUPD$DATA", line 7193
ORA-06512: at "SYS.KUPW$WORKER", line 23049
ORA-06512: at "SYS.KUPW$WORKER", line 4427
ORA-06512: at "SYS.KUPW$WORKER", line 13767
ORA-06512: at "SYS.KUPW$WORKER", line 2429
ORA-06512: at line 2

Mos中可以确认为oracle bug, 当使用datapump通过network_link,目标端=>12.2的版本,源端<12.2, 在导入分区表时内部错误出现ora-600 [qesmaGetPamR-NullCtx] 说明命中此 Bug 30321076, 目前看base版本中是到20C修复,要以选择对应平台的one-off patch. 忽略。

 

如果您无法自己修复此问题,请联系 www.anbob.com 首页上的联系方式。

打赏

, ,

对不起,这篇文章暂时关闭评论。