My Oracle Support Banner

DataPump Import (IMPDP) Fails With Errors ORA-39097 ORA-39065 ORA-56937 (Doc ID 1471910.1)

Last updated on SEPTEMBER 12, 2023

Applies to:

Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

DataPump import of a schema-level dump file from Oracle 11.2.0.2 running on Solaris to Oracle 11.2.0.3 running on Linux SLES fails with errors:

Import: Release 11.2.0.3.0 - Production on Thu Jun 28 14:09:09 2012
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01": system/<password>@<DBLINK_NAME> dumpfile=<DUMPFILE>
logfile=<LOGFILE> schemas=<USERNAME> directory=dp_dir status=10
ORA-39097: Data Pump job encountered unexpected error -56937
ORA-39065: unexpected master process exception in DISPATCH
ORA-56937: failed to load the secondary time zone data file

 The alert.log reports the following error:

ORA-04031: unable to allocate 795552 bytes of shared memory ("large pool","unknown object","large pool","Allocate TT. qesdpiRacAction_cb")

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.