APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1] Information in this document applies to any platform. DESCRIPTION This alert is for unpublished BUG 21480031 - WRONG DUMP FILE VERSION IF COMPATIBLE 12.1.0.2 AND HADOOP TRAILER EVENT NOT SET, which causes the dump file version written to the external table dump file in SQL mode to be 4.2, instead of 4.1. The problem is introduced due to the fix of unpublished BUG 21365364 - ORACLE_DATAPUMP ACCESS DRIVER NEEDS TO SUPPORT FILES ON HDFS. Unpublished BUG 21365364 has been regressed and its correction is done via the fix of unpublished BUG 21480031. OCCURRENCE This issue has potential to affect all DataPump dump files generated from a source database having one of the following installation level: - 12.1.0.2.180417 (Apr 2018) Database Proactive Bundle Patch - 12.1.0.2.180717 (Jul 2018) Database Proactive Bundle Patch, SYMPTOMS The example below describes the problem introduced due to unpublished BUG 21365364: - In source database with Database Bundle Patch : 12.1.0.2.180417: SQL> create user tc identified by tc; User created. SQL> grant dba to tc; Grant succeeded. SQL> create table tc.t1 (id number); Table created. - Export the TC schema: > expdp system/oracle dumpfile=testversion.dmp logfile=testv.txt tables=tc.t1 - Use the generated dump file to import TC schema into a target database having the installation level different than 12.1.0.2.180417 DBBP or 12.1.0.2.180717 DBBP. >impdp system/oracle dumpfile=testversion.dmp logfile=testv.txt Import: Release 12.1.0.2.0 - Production on Thu Jun 14 11:15:58 2018 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 4.2 in dump file "/refresh/oracle/admin/db2/dpdump/testversion.dmp"
==> ORA-39142 is reported when the dump file is processed by a SQL mode select or by a DataPump import into a database having the installation level different than 12.1.0.2.180417DBBP or 12.1.0.2.180717DBBP. WORKAROUND Specify the DataPump parameter VERSION=12.1 (not 12.1.0.2) on the expdp command line. PATCHES Patch 21480031 is available for download to address the problem in the affected Proactive Bundle Patches: 12.1.0.2.180717DBBP or 12.1.0.2.180417DBBP.
To check for conflicting patches, please use the MOS Patch Planner Tool Please refer to Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches? If no patch exists for your version, please contact Oracle Support for a backport request. Note: Patch 21480031 must be applied in the source environment, before generating the export dumps.
The fix for unpublished BUG 21480031 and its regression, unpublished BUG 21365364, is included in: - 12.2 - October 2018 DBBP (12.1.0.2.181016DBBP) |