My Oracle Support Banner

ORA-65139: Mismatch Between XML Metadata File And Data File. Database Not Open Read Only (Doc ID 1963139.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

A non-container database which needs to be plugged into a container database on the same server.  Have already described the non-cdb database and when trying to plug into the cdb,  the following error message occurs:

On non-CDB:

SQL> exec dbms_pdb.describe(pdb_descr_file=>'/u02/oracle/noncdb.xml');

PL/SQL procedure successfully completed.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.



On CDB:

SQL> create pluggable database pdb2 using '/u02/oracle/noncdb.xml' copy file_name_convert=('+DATA','+NEWDATA');
create pluggable database pdb2 using '/u02/oracle/noncdb.xml' copy file_name_convert=('+DATA','+NEWDATA')
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
+DATA/NONCDB/DATAFILE/system.279.868463067 for value of fcpsb (1603184 in the
plug XML file, 1604834 in the data file)



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
Cause
Solution
References


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