Product: Oracle Database
Version: 11.2.0.2
Issue:
bash-3.00$ expdp system/asksystem DIRECTORY=DATA_PUMP_DIR DUMPFILE=Sunil_20120828.dmp SCHEMAS=Sunil logfile=Sunil_20120828.log
Version: 11.2.0.2
Issue:
bash-3.00$ expdp system/asksystem DIRECTORY=DATA_PUMP_DIR DUMPFILE=Sunil_20120828.dmp SCHEMAS=Sunil logfile=Sunil_20120828.log
Export: Release 11.2.0.2.0 - Production on Wed Aug 29 13:45:17 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Username: / as sysdba
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, 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 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1
Cause:
Since Streams pool size value is zero it is unable to proceed. Need to set to proper value
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter STREAMS
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 0
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter STREAMS
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size big integer 0
Solution:
Set Streams_pool_size value to a minimun of 40M value as below.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set streams_pool_size=40M scope=BOTH;
System altered.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set streams_pool_size=40M scope=BOTH;
System altered.
Once set up Stream_pool_size at minimum size on Single instance database or RAC database then retrieve the Datapump Job.
thank you so much for posting details of how you fixed this.
ReplyDeleteIt didn't work immediately:
SQL> alter system set streams_pool_size=40M scope=BOTH;
alter system set streams_pool_size=40M scope=BOTH
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-04033: Insufficient memory to grow pool
so
alter system set sga_max_size=3G scope =spfile;
alter system set shared_pool_size=1G scope=both;
then it workd a treat. Thank you
This comment has been removed by the author.
ReplyDelete