Home > TroubleShooting > Impdp Hung

Impdp Hung

Symptoms

– Start impd and wait for about 2-3 minutes, it didn’t start import the dump file. Finally, I aborted the import as the following

$ impdp system/oracle parfile=imp_vstb.par

Import: Release 11.1.0.7.0 – 64bit Production on Tuesday, 08 December, 2009 15:33:14

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

Connected to: Oracle Database 11g Release 11.1.0.7.0 – 64bit Production

With the Real Application Clusters option

UDI-00001: user requested cancel of current operation <– abort the import

Cause

– Founding the following errors in alert.log

 Errors in file /opt/oracle/diag/rdbms/vstbpro/vstbpro2/trace/vstbpro2_pmon_888.trc:

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

2009-12-08 15:48:46.475000 +08:00

Errors in file /opt/oracle/diag/rdbms/vstbpro/vstbpro2/trace/vstbpro2_pmon_888.trc:

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

– Founding streams_pool_size was zero

Fixed

Increase the streams_pool_size and sga_target size, after that restart the instance

SQL> alter system set sga_target=2048M scope=spfile sid=’vstbpro2′;

System altered.

SQL> alter system set streams_pool_size=50M scope=spfile sid=’vstbpro2′;

System altered.

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: