view counter

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

Thanks to Surachart Opun for this story

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

view counter
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

http://surachartopun.com

Read the entire article at its source

view counter