Database Administration (MOSC)

MOSC Banner

Datapump export from remote database fail when parallel degree > 1

edited Nov 27, 2013 10:03PM in Database Administration (MOSC) 2 commentsAnswered
Oracle DB = 11.2.0.3 (both - source and target)RAC = 3 nodes(target)
RAC = 2 nodes(source)
OS= RH LINUX 6
ISSUE: the datapump export fails when I run in parallel. it complte without any issue when parallel=1

I need to export many schemas from the source DB into target DB. the size of total export is around 3 TB with 20 different schemas.

EXPDP parfile:

userid=testdatapump/password
DUMPFILE=exp_hospitals_from_qadb_%U.dmp
DIRECTORY=remote_datapump_dir
LOGFILE=exp_hospitals_from_qadb.log
FILESIZE=20g
SCHEMAS=hospitals
PARALLEL=4
NETWORK_LINK=dsdb_remote

ERRORS:
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN []

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center