Chinaunix首页 | 论坛 | 博客
  • 博客访问: 2196440
  • 博文数量: 448
  • 博客积分: 1860
  • 博客等级: 上尉
  • 技术积分: 4979
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文(448)

文章存档

2021年(180)

2020年(115)

2019年(11)

2018年(9)

2017年(9)

2016年(17)

2015年(7)

2014年(4)

2013年(1)

2012年(11)

2011年(27)

2010年(35)

2009年(11)

2008年(11)

分类: Oracle

2021-09-17 14:55:04


导入100M的dmp,运行2分钟后报错ora-4030。
free -m 16G,sga 10g pga 2g
oracle 11.2.0.4单机

  1. 导入命令

  2. impdp SCOTT/SCOTT directory=DIR1 dumpfile=A_1_cur.dmp table_exists_action=replace
  3. exclude="user:\"='SCOTT'\"" logfile=A_.log
  4. Import: Release 11.2.0.4.0 - Production on Fri Sep 17 13:55:45 2021
  5. Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
  6. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  7. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  8. Master table "SCOTT"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
  9. Starting "SCOTT"."SYS_IMPORT_FULL_02": SCOTT/******** directory=DIR1 dumpfile=A_1_cur.dmp table_exists_action=replace exclude=user:"='SCOTT'" logfile=A_.log
  10. Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
  11. Processing object type SCHEMA_EXPORT/ROLE_GRANT
  12. Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
  13. Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
  14. Processing object type SCHEMA_EXPORT/PASSWORD_HISTORY
  15. ORA-39014: One or more workers have prematurely exited.
  16. ORA-39029: worker 1 with process name "DW00" prematurely terminated
  17. ORA-31671: Worker process DW00 had an unhandled exception.
  18. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
  19. ORA-06512: at "SYS.KUPW$WORKER", line 1887
  20. ORA-06512: at line 2
  21. 报错日志:
  22. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  23. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  24. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  25. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  26. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  27. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  28. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  29. DDE: Problem Key 'ORA 4030' was flood controlled (0x2) (incident: 296434)
  30. ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
  31. ORA-06512: at "SYS.KUPW$WORKER", line 1887
  32. ORA-06512: at line 2
  33. *** 2021-09-17 13:41:35.381
  34. KUPP: Error 4030 detected in worker process DW01, worker id=2
  35. OPIRIP: Uncaught error 27102. Error stack:
  36. ORA-27102: out of memory
  37. Linux-x86_64 Error: 12: Cannot allocate memory
  38. Additional information: 108
  39. Additional information: 1441792
  40. ORA-00448: normal completion of background process
  41. ORA-31671: Worker process DW01 had an unhandled exception.
  42. ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
  43. ORA-06512: at "SYS.KUPW$WORKER", line 1887
  44. ORA-06512: at line 2

 关键trc文件(看alert.log里的提示)
  1. more /oracle/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_296425/orcl_dw00_24864_i296425.trc
  2. Dump file /oracle/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_296425/orcl_dw00_24864_i296425.trc
  3. Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
  4. With the Partitioning, OLAP, Data Mining and Real Application Testing options
  5. ORACLE_HOME = /oracle/app/oracle/product/11.2.0/db_1
  6. System name: Linux
  7. Node name: DB1
  8. Release: 2.6.32-504.el6.x86_64
  9. Version: #1 SMP Tue Sep 16 01:56:35 EDT 2014
  10. Machine: x86_64
  11. VM name: VMWare Version: 6
  12. Instance name: orcl
  13. Redo thread mounted by this instance: 1
  14. Oracle process number: 40
  15. Unix process pid: 24864, image: oracle@DB1 (DW00)
  16. *** 2021-09-17 13:39:50.572
  17. *** SESSION ID:(13.15451) 2021-09-17 13:39:50.572
  18. *** CLIENT ID:() 2021-09-17 13:39:50.572
  19. *** SERVICE NAME:(SYS$BACKGROUND) 2021-09-17 13:39:50.572
  20. *** MODULE NAME:(Data Pump Worker) 2021-09-17 13:39:50.572
  21. *** ACTION NAME:(SYS_IMPORT_FULL_01) 2021-09-17 13:39:50.572
  22. Dump continued from file: /oracle/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_dw00_24864.trc
  23. ORA-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxLpxAlloc)
  24. ========= Dump for incident 296425 (ORA 4030) ========
  25. ----- Beginning of Customized Incident Dump(s) -----
  26. =======================================
  27. TOP 10 MEMORY USES FOR THIS PROCESS
  28. ---------------------------------------
  29. 96% 6444 MB, 562102 chunks: "kuxLpxAlloc "                 <<<-----------妈呀,已经6G了!
  30. session heap ds=0x7f90cbce61a0 dsprt=0xc0d2140
  31. 3% 231 MB, 22075 chunks: "free memory "
  32. top uga heap ds=0xc0d2140 dsprt=(nil)
  33. 0% 28 MB, 43334 chunks: "free memory "
  34. session heap ds=0x7f90cbce61a0 dsprt=0xc0d2140
  35. 0% 6368 KB, 34 chunks: "free memory "
  36. pga heap ds=0xc0cc6e0 dsprt=(nil)
  37. 0% 1936 KB, 89 chunks: "free memory "
  38. Alloc environm ds=0x7f90cbd0e090 dsprt=0x7f90cbce61a0
  39. 0% 1781 KB, 33 chunks: "free memory "
  40. top call heap ds=0xc0d1f20 dsprt=(nil)
  41. 0% 1647 KB, 7 chunks: "free memory "
  42. koh-kghu sessi ds=0x7f90cb8a8b00 dsprt=0x7f90cbce61a0
  43. 0% 1006 KB, 20 chunks: "kpmalloc "
  44. koh-kghu sessi ds=0x7f90cb40c0f8 dsprt=0x7f90cbce61a0
  45. 0% 795 KB, 35 chunks: "static frame of inst " PL/SQL
  46. koh-kghu sessi ds=0x7f90cabb7b00 dsprt=0x7f90cbce61a0
  47. 0% 530 KB, 28 chunks: "recursive addr reg file " PL/SQL
  48. koh-kghu sessi ds=0x7f90cbbb1b08 dsprt=0x7f90cbce61a0
  49. =======================================
  50. PRIVATE MEMORY SUMMARY FOR THIS PROCESS
  51. ---------------------------------------
  52. ******************************************************
  53. PRIVATE HEAP SUMMARY DUMP
  54. 6724 MB total:
  55. 6485 MB commented, 237 KB permanent
  56. 239 MB free (7871 KB in empty extents),
  57. 6714 MB, 1 heap: "session heap " 231 MB free held
  58. *** 2021-09-17 13:39:50.910
  59. ------------------------------------------------------
  60. Summary of subheaps at depth 1
  61. 6481 MB total:
  62. 6453 MB commented, 193 KB permanent
  63. 28 MB free (47 KB in empty extents),
  64. 6471 MB, 562102 chunks: "kuxLpxAlloc " 28 MB free held
  65. =========================================
  66. REAL-FREE ALLOCATOR DUMP FOR THIS PROCESS
  67. -----------------------------------------
  68. Dump of Real-Free Memory Allocator Heap [0x7f90cbcb6000]
  69. mag=0xfefe0001 flg=0x5000003 fds=0x8 blksz=65536
  70. blkdstbl=0x7f90cbcb6010, iniblk=111616 maxblk=524288 numsegs=156
  71. In-use num=65389 siz=2756640768, Freeable num=0 siz=0, Free num=1 siz=10485760
  72. ==========================================

解决方案是 增加 exclude=PASSWORD_HISTORY
有一次在comments时遇到 Data Pump Worker 报错,也是exclude跳过,经常见的情况是statistics时报错。


参考:

  1. ORA-39126:KUPW$WORKER.PUT_DDLS [PASSWORD_HISTORY] 中的worker意外的致命错误(文档 ID 2114832.1)

阅读(183) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~