嘗試使用data pump時出錯解決

pingley發表於2012-03-19
嘗試使用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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章