Shulou(Shulou.com)06/01 Report--

Stream pool setting is too small to lead to impdp failure, I believe that many inexperienced people do not know what to do, so this article summarizes the causes of the problem and solutions, through this article I hope you can solve this problem.

The following problems were encountered when the data pump was imported

[oracle@justin pump] $impdp justin/*** directory=pump dumpfile=justin_20110316.dmp

Import: Release 11.2.0.1.0-Production on Thu Mar 31 12:32:35 2011

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-64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining

Oracle Database Vault and Real Application Testing options

UDI-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

Check out the metalink and have the following explanation

Cause

For submitting an export job with datapump utility, we use queues, streams and java objects.

SQL tracing confirms that.

If we see any component is not valid in the database, we will see these errors.

By querying dba_registry we find the different component and their status.

SELECT comp_name, status, version

FROM dba_registry

Solution

We can validate different components in the database by running $ORACLE_HOME/rdbms/admin/catpatch.sql via SQL*Plus:

Spool catpatch.log

Connect / as sysdba

Shutdown immediate

Startup migrate

SELECT comp_name, version, status

FROM dba_registry

Spool off

If you are on 10g Release 2, then perform.:

Connect / as sysdba

Spool dictreload.log

Startup restrict

Alter system set shared_pool_size = 512m scope=spfile

Alter system set java_pool_size = 150m scope=spfile

Alter system set aq_tm_processes = 1 scope=spfile

Alter system set cluster_database = false scope=spfile;-- If on RAC

Shutdown immediate

Startup upgrade

Spool off

Alter system set cluster_database = true scope=spfile;-- If on RAC

Shutdown immediate

Startup

When I read it, I felt completely out of line, so I checked the alertlog. It turned out that it was caused by the small setting of streams pool.

ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool", "unknown object", "streams pool", "fixed allocation callback")

Incident details in: / oracle10g/diag/rdbms/justin/justin/incident/incdir_40167/justin_ora_10439_i40167.trc

Check the sga, only the smallest 564m, and this parameter cannot be modified directly through the alter command.

SQL > show parameter sga_ma

NAME TYPE VALUE

-

Sga_max_size big integer 564M

SQL > ALTER SYSTEM set sga_max_size=1g

ALTER SYSTEM set sga_max_size=1g

*

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

Manually modify the init file, set sga_max_size to 2g, then generate spfile, and execute the import successfully again

After reading the above, have you mastered the method of what to do if the stream pool setting is too small and impdp fails? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.