Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error in expdp of remote database

James LeppDec 10 2015 — edited Feb 29 2016

Hello,

 

When attempting to complete an export on a remote DB I am getting the following errors:

 

ORA-39006: internal error

ORA-39065: unexpected master process exception in DISPATCH

ORA-06575: Package or function KUPM$MCP is in an invalid state

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

Local DB running the export

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

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0              Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 – Production

Remote DB being exported

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0- 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE    12.1.0.2.0              Production

TNS for Linux: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

Export command

expdp / full=y directory=db_dump network_link=remote_db dumpfile=db.dmp logfile=db.log compression=all parallel=3 job_name=db_dump exclude=statistics,table\:\"IN\(\'\PLAN_TABLE\',\'TOAD_PLAN_TABLE\',\'OL\$\'\)\"

Please note the remote DB is a Data Guard DR for my production server, the following sql commands are used to bring the remote DB online for export:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ALTER DATABASE OPEN READ ONLY;

This process worked when both local and remote DBs were 11g, what am I missing here to complete this export with 12c?

Thanks

This post has been answered by James Lepp on Feb 29 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 28 2016
Added on Dec 10 2015
14 comments
3,964 views