Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to plug non-cdb as a pdb

DDebJun 8 2017 — edited Jun 8 2017

Hello experts,

                       I am trying to plug a non-cdb(12.1.0.2 version with Jan 2017 PSU) into a container database with same patchset and in the same server.I followed below steps.

1.Shutdown and open non cdb as read only.

2.Generated xml file in non-cdb

SQL> exec dbms_pdb.describe('/u009/scripts/dba/DD/orcl.xml');

3.Open non-cdb agin in read write mode

4.Created necessary directory for new pdb and tried to create like below

SQL> !mkdir -p /oradata/ccbx12c/exnoncdb

SQL> create pluggable database exnoncdb
as clone
using '/u009/scripts/dba/DD/orcl.xml'
file_name_convert=('/oradata/ccbx','/oradata/ccbx12c/exnoncdb')
copy;  2    3    4    5
create pluggable database exnoncdb
*
ERROR at line 1:
ORA-65139: Mismatch between XML metadata file and data file
/oradata/ccbx/system01.dbf for value of fcpsb (1468424109 in the plug XML file,
1468424112 in the data file)

Please let me know whether I am doing anything wrong here?

Regards

Dhritiman Deb

This post has been answered by Markus Flechtner on Jun 8 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 6 2017
Added on Jun 8 2017
6 comments
1,666 views