合 数据泵导入报错UDI-03113、UDI-03114和ORA-03113、ORA-03114、ORA-04036参数pga_aggregate_limit太小
Tags: Oracle数据泵impdpORA-03113ORA-03114UDI-03113UDI-03114
现象
Oracle 19c,windows 2016 server环境,数据泵通过network_link直接迁移数据,标准版不能使用并行,200g数据量,跑了8个小时,在快结束的时候报错了:
1 2 3 4 5 6 7 8 9 10 11 | . . imported "P10"."F98ABCDE70628E" 10 rows UDI-03113: operation generated ORACLE error 3113 ORA-03113: end-of-file on communication channel Process ID: 4396 Session ID: 255 Serial number: 49187 UDI-03114: operation generated ORACLE error 3114 ORA-03114: not connected to ORACLE |
分析
attach进去后,可以看到部分错误:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 | C:\Users\lhr>impdp system/"lhr"@127.0.0.1/jdp attach=SYS_IMPORT_FULL_01 Import: Release 19.0.0.0.0 - Production on Sat Dec 10 08:12:37 2022 Version 19.15.0.0.0 Copyright (c) 1982, 2022, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production ORA-31626: job does not exist ORA-31638: cannot attach to job SYS_IMPORT_FULL_01 for user SYSTEM ORA-06512: at "SYS.KUPV$FT", line 402 ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT_INT", line 498 ORA-39077: unable to subscribe agent KUPC$A_1_081239903000000 to queue "KUPC$C_1_20221210000552_0" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPC$QUE_INT", line 294 ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9306 ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1873 ORA-06512: at "SYS.DBMS_PRVTAQIS", line 77 ORA-06512: at "SYS.DBMS_PRVTAQIS", line 169 ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1724 ORA-06512: at "SYS.DBMS_PRVTAQIS", line 1516 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9900 ORA-06512: at "SYS.DBMS_AQADM_SYS", line 9269 ORA-06512: at "SYS.DBMS_AQADM", line 881 ORA-06512: at "SYS.KUPC$QUE_INT", line 267 ORA-06512: at "SYS.KUPC$QUE_INT", line 1360 ORA-06512: at line 1 ORA-06512: at "SYS.KUPC$QUEUE_INT", line 65 ORA-06512: at "SYS.KUPV$FT_INT", line 465 ORA-06512: at "SYS.KUPV$FT", line 335 |