Just Data Pump : ORA-39006, ORA-39065, ORA-39097

Nothing to write on B*** time :) I just keep tracking with Error what I saw. I tested Oracle Data Pump... but I found error.

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-39097: Data Pump job encountered unexpected error -6512

Maybe, In this case, I should check streams_pool_size initialization parameter. I remembered I use SGA_TARGET initialization parameter. Anyway, just make it works :)

$ impdp system NETWORK_LINK=network_link FULL=Y CONTENT=METADATA_ONLY

Import: Release 11.2.0.3.0 - Production on Thu Mar 29 10:31:48 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-39097: Data Pump job encountered unexpected error -6512

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Mar 29 10:34:29 2012

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> show parameter sga_target

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

sga_target big integer 768M

SQL> show parameter stream

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

streams_pool_size big integer 0

SQL> alter system set streams_pool_size=64M;

System altered.

$ impdp system NETWORK_LINK=network_link FULL=Y CONTENT=METADATA_ONLY

Import: Release 11.2.0.3.0 - Production on Thu Mar 29 10:34:47 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** NETWORK_LINK=network_link FULL=Y CONTENT=METADATA_ONLY

In the bottom line, I just set value for streams_pool_size initialization parameter. Although, I use SGA_TARGET parameter.

Reference:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_perf.htm