ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 尝试使用data pump时出错解决

尝试使用data pump时出错解决

原创 Linux操作系统 作者:pingley 时间:2012-03-19 09:09:53 0 删除 编辑
尝试使用data pump时出错解决
尝试使用data pump 的时候遇到如下错误。
[oracle@zeng ~]$ expdp system/zengping
Export: Release 11.2.0.1.0 - Production on Fri Mar 16 15:31:01 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 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 3263
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4488
ORA-06512: at line 1
查看日志信息查找原因。
oracle@zeng ~]$ adrci
ADRCI: Release 11.2.0.1.0 - Production on Fri Mar 16 15:32:33 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
ADR base = "/opt/oracle11g"
adrci> show home
ADR Homes: 
diag/tnslsnr/zeng/listener
diag/rdbms/oracl/oracl
adrci> set homepath diag/rdbms/oracl/oracl
adrci> show alert -tail 10 
2012-03-16 15:31:09.836000 +08:00
Errors in file /opt/oracle11g/diag/rdbms/oracl/oracl/trace/oracl_ora_3160.trc  (incident=49436):
ORA-04031: unable to allocate 32 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
Incident details in: /opt/oracle11g/diag/rdbms/oracl/oracl/incident/incdir_49436/oracl_ora_3160_i49436.trc
2012-03-16 15:31:17.660000 +08:00
Trace dumping is performing id=[cdmp_20120316153117]
2012-03-16 15:31:20.151000 +08:00
Sweep [inc][49436]: completed
Sweep [inc2][49436]: completed
注意其中的:
ORA-04031: unable to allocate 32 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
说不能在streams pool 中分配到32 bytes的共享内存,因为我streams pool设置成了0.
修改streams pool 的大小,并重启数据库。
SQL> alter system set streams_pool_size=20M scope=spfile;
System altered.
SQL> shutdown immediate
SQL> startup
再次尝试使用data pump 出现下面的错误。
ORA-04031: unable to allocate 16 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","SQLA","tmp")
增大share pool 的大小。
SQL> alter system set shared_pool_size=110M;
System altered.
再次尝试使用data dump。
[oracle@zeng ~]$ expdp system dumpfile=test.dmp    
Export: Release 11.2.0.1.0 - Production on Fri Mar 16 16:33:06 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
Password: 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_05":  system/******** dumpfile=test.dmp 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
.
.
.
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_05 is:
  /opt/oracle11g/admin/oracl/dpdump/test.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_05" successfully completed at 16:35:55
成功了.

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

上一篇: linux I/O 瓶颈监控
请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    169
  • 访问量
    741582