DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-12801 ORA-1460 In RAC Environment (Doc ID 1427537.1)

Last updated on OCTOBER 08, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 08-Oct-2013***

Symptoms

The following errors are being reported in the import log:

Import: Release 11.2.0.2.0 - Production on Lun. Févr. 6 10:07:26 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "AGRT997"."IMPDP_MDHP1_201202006100500" successfully loaded/unloaded
Starting "AGRT997"."IMPDP_MDHP1_201202006100500": AGRT997/******** PARFILE=D:\Batch\script_gen\DP_IMP_MDHP1_pour_S1.PAR
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "AGRMDHS1"."DOCMNIMAGE"          4.455 GB      65505 rows
ORA-39097: Data Pump job encountered unexpected error -12801
ORA-39065: unexpected master process exception in MAIN
ORA-12801: error signaled in parallel query server PZ99, instance QUBC1-SGBDA16N:accp2 (2)
ORA-01460: unimplemented or unreasonable conversion requested
Job "AGRT997"."IMPDP_MDHP1_201202006100500" stopped due to fatal error at 10:19:51

 

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