ORA-65139: Mismatch between XML metadata file and data file



Error:

CDB$ROOT@EBTUPRDC> CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse;
CREATE PLUGGABLE DATABASE EBTUSPRDPDB1 using '/home/oracle/EBTUSPRDC.xml' nocopy tempfile reuse
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/u05/odb/ORADATA_1/EBTUSPRDC/datafile/system.1531.807800993 for value of fcpsb
(2230502002 in the plug XML file, 2230505492 in the data file)




Fix: Don't open Non-CDB database until we complete pdb creation other wise we will get above error.

Shutdown immediate;
startup mount;
alter database open read only;

create xml file.

shutdown immediate;


Connect to CDB and Create Pluggable database .


Comments

  1. I am faced this error . Find your recommendation during the search and followed the step .Issue got resolved .Thanks a lot

    ReplyDelete
  2. elstinzon_ko Jessica Gonzalez Download
    poolneposan

    ReplyDelete

Post a Comment

Popular posts from this blog

Useful OEM Queries to get Target details from OEM Repository

WARNING: Subscription for node down event still pending' in Listener Log