ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052

在导出的时候

expdp system/ets    directory=dumpdir dumpfile=chimei_expdp schemas=chimei logfile=exp_kanekoh.log

oracle@mdsetsdb02:/oracle11g/oracle>./expdp_kanekoh.sh

 

Export: Release 11.1.0.6.0 - 64bit Production on Wednesday, 17 October, 2012 9:24:28

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

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 2862

ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052

ORA-06512: at line0 1]

 

 

 

Check log:

Errors in file /export/home/oracle/diag/rdbms/mdsets/MDSETS/trace/MDSETS_ora_224

0.trc  (incident=24971):

ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown

 object","streams pool","fixed allocation callback")

Incident details in: /export/home/oracle/diag/rdbms/mdsets/MDSETS/incident/incdi

r_24971/MDSETS_ora_2240_i24971.trc

Wed Oct 17 09:27:44 2012

Trace dumping is performing id=[cdmp_20121017092744]

Wed Oct 17 09:27:51 2012

Sweep Incident[24971]: completed

 
 
加大streams_pool_size的值,试过减少shared_pool 和db_cache_size的值,还是没用,只能加大streams_pool_size
 
加大之后重新expdp出现

With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user CHIMEI

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT", line 1481

ORA-39062: error creating master process DM00

ORA-39105: Master process DM00 failed during startup. Master error:

ORA-06533: Subscript. beyond count

 

该错误可能是权限不够还是怎么了

之后用systme 导出竟然可以了

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24849178/viewspace-746611/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/24849178/viewspace-746611/

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值