DataPump Export (EXPDP) Using A Network Link To A Standby Database Fails With Errors ORA-31626 ORA-31633 ORA-6512 ORA-16000 (Doc ID 805414.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
***Checked for relevance on 11-Apr-2013***

Symptoms

DataPump export via a NETWORK_LINK fails with ORA-00600 [4466]

If you want to perform DataPump export on a physical standby database directly which is on read only mode, then you will not be able to do that, because DataPump Master Process cannot create the master table in a read only database. This master table is needed for any kind of operation. An export DataPump job from a read only database will therefore fail with:

ORA-31633: unable to create master table "XXX.YYY"


The following errors could be presented in this scenario:

Connected to: Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response


and:

ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [4466], [9], [], [], [], [], [], [], [], [], [], []


If you then try to export from a remote database via a network_link connected to the standby database, then you can run into
<Bug 7331929> - DATAPUMP EXPORT FROM STANDBY DATABASE FAILS ORA-16000

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms