测试环境，导出个数据，但是报错了。
[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
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
简单搜索一番，没找到解决方案，回想当前测试环境，内存本身很小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)
阅读(2772) | 评论(0) | 转发(0) |
