ORA-07445: 出现异常错误: 核心转储 [kupfuDecompress()+2279]

问题背景： 客户expdp导出数据的时候程序以外中止，协助排查问题原因 问题处理： 报错如下   查看alert日志 Dump file c:\app\administrator\diag\rdbms\crm\crm\incident\incdir_131384\crm_dw00_5696_i131384.trc Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Windows NT Version V6.1 Service Pack 1  CPU                 : 16 - type 8664, 16 Physical Cores Process Affinity    : 0x0x0000000000000000 Memory (Avail/Total): Ph:10000M/16383M, Ph+PgF:26083M/32765M  VM name             : VMWare Version (6) Instance name: crm Redo thread mounted by this instance: 1 Oracle process number: 30 Windows thread id: 5696, image: ORACLE.EXE (DW00) *** 2020-03-22 17:55:42.649 *** SESSION ID:(690.599) 2020-03-22 17:55:42.649 *** CLIENT ID:() 2020-03-22 17:55:42.649 *** SERVICE NAME:(SYS$BACKGROUND) 2020-03-22 17:55:42.649 *** MODULE NAME:(Data Pump Worker) 2020-03-22 17:55:42.649 *** ACTION NAME:(SYS_IMPORT_FULL_01) 2020-03-22 17:55:42.649   Dump continued from file: c:\app\administrator\diag\rdbms\crm\crm\trace\crm_dw00_5696.trc ORA-07445: 出现异常错误: 核心转储 [kupfuDecompress()+2279] [ACCESS_VIOLATION] [ADDR:0x10] [PC:0x521B77B] [UNABLE_TO_READ] [] ========= Dump for incident 131384 (ORA 7445 [kupfuDecompress()+2279]) ======== ----- Beginning of Customized Incident Dump(s) ----- Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x10] [PC:0x521B77B, kupfuDecompress()+2279] Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production Process Id: 0x00000730  Thread Id : 0x00001640    Time : Sun Mar 22 17:55:42  Excp. Code: 0xc0000005  Excp. Type: ACCESS_VIO    Flags: 0x00000000 ------------------- Registers ---------------------------- ip=000000000521B77B sp=000000002552F0D0 rp=000000001A1074A0 r1=0000000000000001 r2=000000000521B774 r3=0000000000400000  r4=0000000000000000 r5=000000002552F0D0 r6=000000001A1074A0 r7=0000000000000000  r8=0000000000000000 r9=000000002AFD09D0 r10=000000002AF2FE00 r11=0000FFF1077DF569  r12=0000000000000000 r13=0000000000000000 r14=000000002552F680 r15=000000002AFD09D0  ------------------- End of Registers --------------------- *** 2020-03-22 17:55:42.665 dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x3, level=3, mask=0x0) ----- Current SQL Statement for this session (sql_id=ggatk0yxyd8r7) -----  BEGIN    SYS.KUPW$WORKER.MAIN('SYS_IMPORT_FULL_01', 'CRM', 0);  END; ----- PL/SQL Stack ----- ----- PL/SQL Call Stack -----   object      line  object   handle    number  name 00000002FBA9BE10        58  package body SYS.KUPD$DATA_INT 00000002FC79FD70      3104  package body SYS.KUPD$DATA 00000002FC7BF030     14187  package body SYS.KUPW$WORKER 00000002FC7BF030      4412  package body SYS.KUPW$WORKER 00000002FC7BF030      8889  package body SYS.KUPW$WORKER 00000002FC7BF030      1649  package body SYS.KUPW$WORKER 00000002FC7C0C78         2  anonymous block ----- Call Stack Trace ----- calling              call     entry                argument values in hex       location             type     point                (? means dubious value)      -------------------- -------- -------------------- ---------------------------- kupfuDecompress()+2           0000000000000000     2020202020202020 279                                                6E6F6E6120203220                                                    6C622073756F6D79  BEGIN    SYS.KUPW$WORKER.MAIN('SYS_IMPORT_FULL_01', 'CRM', 0);  END; 这个sql是数据泵使用使用的sql，没办法避免了，采用exp的方式导出数据，建议客户及时迁移

更多内容请关注微信公众号：数据与人