Friday, March 30, 2012

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

1 comment:

davidp said...

Yes, my experience with datapump on Oracle 10.2 is that the oracle streams pool seems to get fragmented - increasing or decreasing the streams_pool_size resolves the issue.