ANIL VEJENDLA

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 .

12c NON-CDB to Container PDB   Steps for Non-CDB : EBTUSPRD@EBTUSPRD> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. EBTUSPRD@EBTUSPRD> startup mount ORACLE instance started. Total System Global Area 3355443200 bytes Fixed Size                  8626240 bytes Variable Size            1040191424 bytes Database Buffers         2164260864 bytes Redo Buffers              142364672 bytes Database mounted. EBTUSPRD@EBTUSPRD> alter database open read only; Database altered. Create XML file: BEGIN   DBMS_PDB.DESCRIBE(     pdb_descr_file => '/home/oracle/EBTUSPRDC.xml'); END; / PL/SQL procedure successfully completed. Shutdown NON-CDB: EBTUSPRD@EBTUSPRD> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. Steps for Container Database: SET SERVEROUTPUT ON DECLARE   compatible CONSTANT VARCHAR2(3) :=       CASE DBMS_PDB.CH