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 and later
Information in this document applies to any platform.


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.


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)


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

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