expdp 导出报错 ora-凯发app官方网站

测试环境，导出个数据，但是报错了。

[oracle@apex ~]$ expdp \'/ as sysdba \' directory=dir1 dumpfile=a.dmp schemas=abc

export: release 19.0.0.0.0 - production on thu mar 25 19:59:25 2021
version 19.10.0.0.0

凯发app官方网站 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

ude-31623: operation generated oracle error 31623
ora-31623: a job is not attached to this session via the specified handle
ora-06512: at "sys.dbms_datapump", line 4747
ora-06512: at "sys.kupv$ft_int", line 2144
ora-06512: at "sys.dbms_sys_error", line 79
ora-06512: at "sys.kupv$ft_int", line 2081
ora-06512: at "sys.dbms_datapump", line 2263
ora-06512: at "sys.dbms_datapump", line 4496
ora-06512: at "sys.dbms_datapump", line 6127
ora-06512: at line 1

简单搜索一番，没找到凯发app官方网站的解决方案，回想当前测试环境，内存本身很小1.5g，曾经测试过一些参数。

检查alert.log有告警日志
ora-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")

将隐含参数 _ash_size 设置为64m或和删除这个隐含参数，重启实例后就可以正常导出了。

[oracle@apex ~]$ opatch lspatches
32067171;ojvm release update: 19.10.0.0.210119 (32067171)
32218454;database release update : 19.10.0.0.210119 (32218454)
29585399;ocw release update 19.3.0.0.0 (29585399)

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

上一篇：如何评估一个表占用空间大小

下一篇：oracle 安全加固 abc

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

| | | | |

感谢所有关心和支持过chinaunix的朋友们