I have a 12.1.0.1 database in which I wanted to migrate a number of PDBs to AL32UTF character set. To do this I created a second (temporary) database with the correct characterset, unplugged and re-plugged each PDB and ran the DMA U to migrate the PDBs - all went well.
I then dropped the first database and built another again with the correct characterset.
When I unplug and replug the PDBs from the temporary to the new database I get the following PDB violation:
PDB_ACPT_CLONE SQL patch 19648840 mismatch: Installed in the PDB but not in the CDB.
This patch had been applied to the original database and then rolled back before the temporary and new databases were created.
datapatch shows:
C:\oracle\product\12.1.0\dbhome_1\OPatch>datapatch -verb
SQL Patching tool version 12.1.0.1.0 on Wed Jan 21 09:43
Copyright (c) 2012, Oracle. All rights reserved.
Connecting to database...OK
Determining current state...
Currently installed SQL Patches:
PDB CDB$ROOT:
PDB PDB$SEED:
PDB PDB_ORCL12C:
PDB PDB_ACPT_CLONE:
Currently installed C Patches:
For the following PDBs: CDB$ROOT
Nothing to roll back
Nothing to apply
For the following PDBs: PDB$SEED
Nothing to roll back
Nothing to apply
For the following PDBs: PDB_ORCL12C
Nothing to roll back
Nothing to apply
For the following PDBs: PDB_ACPT_CLONE
Nothing to roll back
Nothing to apply
SQL Patching tool complete on Wed Jan 21 09:43:44 2015
C:\oracle\product\12.1.0\dbhome_1\OPatch>
PDB_ORCL12C was created in the new database.
The moved PDB is now stuck in RESTRICTED mode.
Any ideas on how to resolve this?