My Oracle Support Banner

ORA-39142 ORA-39000 when importing AWR Performance Data from 11.2 to earlier release (Doc ID 1359703.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Apr-2013***

Symptoms

Transfer of Automatic Workload Repository snapshots
It is possible for administrators to transfer Automatic Workload Repository snapshots to other workload repositories for offline analysis. This is accomplished by the administrator specifying a snapshot range and extracting the AWR data to a Data Pump Dumpfile.

The dumpfile is then loaded into a user-specified staging schema in the target repository. To complete the transfer, the data is copied from the staging schema into the target repository's SYS schema. The data in the SYS schema is then used as the source for the ADDM analysis.


Steps to execute

@?/rdbms/admin/awrextr.sql
@?/rdbms/admin/awrload


ISSUE

ORA-20115: datapump import encountered error:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/test/AWR_expdp.dmp"
ORA-06512: at "SYS.DBMS_SWRF_INTERNAL", line 1539
ORA-06512: at line 4

Changes

AWR data export:

@?/rdbms/admin/awrextr.sql

AWR data import:

@?/rdbms/admin/awrload.sql

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.