impdp ora-凯发app官方网站

凯发app官方网站-凯发k8官网下载客户端中心 | | 凯发app官方网站-凯发k8官网下载客户端中心

沧海拾贝

凯发app官方网站首页　| 　博文目录　| 　关于我

brjl

  • 博客访问： 3502889
  • 博文数量： 718
  • 博客积分： 1860
  • 博客等级： 上尉
  • 技术积分： 7790
  • 用 户 组： 普通用户
  • 注册时间： 2008-04-07 08:51
个人简介

偶尔有空上来看看

文章分类

全部博文（718）

文章存档

2024年（4）

2023年（74）

2022年（134）

2021年（238）

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）

我的朋友
最近访客
推荐博文
相关博文
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
  • ·
impdp ora-04030 password_history 的处理

分类： 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. 导入命令

  3. impdp scott/scott directory=dir1 dumpfile=a_1_cur.dmp table_exists_action=replace
  4. exclude="user:\"='scott'\"" logfile=a_.log
  5. import: release 11.2.0.4.0 - production on fri sep 17 13:55:45 2021
  6. 凯发app官方网站 copyright (c) 1982, 2011, oracle and/or its affiliates. all rights reserved.
  7. connected to: oracle database 11g enterprise edition release 11.2.0.4.0 - 64bit production
  8. with the partitioning, olap, data mining and real application testing options
  9. master table "scott"."sys_import_full_02" successfully loaded/unloaded
  10. starting "scott"."sys_import_full_02": scott/******** directory=dir1 dumpfile=a_1_cur.dmp table_exists_action=replace exclude=user:"='scott'" logfile=a_.log
  11. processing object type schema_export/system_grant
  12. processing object type schema_export/role_grant
  13. processing object type schema_export/default_role
  14. processing object type schema_export/tablespace_quota
  15. processing object type schema_export/password_history
  16. ora-39014: one or more workers have prematurely exited.
  17. ora-39029: worker 1 with process name "dw00" prematurely terminated
  18. ora-31671: worker process dw00 had an unhandled exception.
  19. ora-04030: out of process memory when trying to allocate 120048 bytes (session heap,kuxlpxalloc)
  20. ora-06512: at "sys.kupw$worker", line 1887
  21. ora-06512: at line 2
  22. 报错日志：
  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. mmap(offset=217747456, len=4096) failed with errno=12 for the file ora_dw01_orcl
  30. dde: problem key 'ora 4030' was flood controlled (0x2) (incident: 296434)
  31. ora-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxlpxalloc)
  32. ora-06512: at "sys.kupw$worker", line 1887
  33. ora-06512: at line 2
  34. *** 2021-09-17 13:41:35.381
  35. kupp: error 4030 detected in worker process dw01, worker id=2
  36. opirip: uncaught error 27102. error stack:
  37. ora-27102: out of memory
  38. linux-x86_64 error: 12: cannot allocate memory
  39. additional information: 108
  40. additional information: 1441792
  41. ora-00448: normal completion of background process
  42. ora-31671: worker process dw01 had an unhandled exception.
  43. ora-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxlpxalloc)
  44. ora-06512: at "sys.kupw$worker", line 1887
  45. 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. ==========================================

凯发app官方网站的解决方案是 增加 exclude=password_history
有一次在comments时遇到 data pump worker 报错，也是exclude跳过，经常见的情况是statistics时报错。


参考：

  1. ora-39126：kupw$worker.put_ddls [password_history] 中的worker意外的致命错误（文档 id 2114832.1）

阅读(1919) | 评论(0) | 转发(0) |
0

上一篇：a用户要访问b用户所有表、视图、存储过程、包

下一篇：19c dbms_job ora-27486

给主人留下些什么吧！~~
| | | | |

凯发app官方网站 copyright 2001-2010 chinaunix.net all rights reserved 北京皓辰网域网络信息技术有限公司. 凯发k8官网下载客户端中心的版权所有

感谢所有关心和支持过chinaunix的朋友们
")); function link(t){ var href= $(t).attr('href'); href ="?url=" encodeuricomponent(location.href); $(t).attr('href',href); //setcookie("returnouturl", location.href, 60, "/"); }
网站地图