Thursday, July 25, 2013

Compatiblity Quirks of PDB with CDB of pluggable database feature of Oracle 12c

I was playing with converting an existing Oracle database to pluggable database and to plug it in the container database. Earlier I had created that non-CDB or in other words the good old database in 12c without any options like APEX etc.

Before plugging this non-CDB database into the CDB, I checked the compatibility and it said 'No'.



 SQL> SET SERVEROUTPUT ON  
 DECLARE  
  compatible CONSTANT VARCHAR2(3) :=  
   CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(  
       pdb_descr_file => '/u01/app/oracle/oradata/targettest/targettest.xml',  
       pdb_name    => 'targettest')  
   WHEN TRUE THEN 'YES'  
   ELSE 'NO'  
 END;  
 BEGIN  
  DBMS_OUTPUT.PUT_LINE(compatible);  
 END;  
 /SQL>  2  3  4  5  6  7  8  9  10  11  12   
 NO  
In order to see what the compatibility violations are, use:

SQL> select message, action from PDB_PLUG_IN_VIOLATIONS;

MESSAGE                       ACTION
--------------------------------------------- ---------------------------------------------
CDB parameter recyclebin mismatch: Previous O Please check the parameter in the current CDB
FF Current on

CDB parameter recyclebin mismatch: Previous O Please check the parameter in the current CDB
FF Current on

Database option APS mismatch: PDB installed v Install or upgrade the database option in the
ersion NULL. CDB installed version 12.1.0.1.0  PDB or CDB
.

Database option CONTEXT mismatch: PDB install Install or upgrade the database option in the
ed version NULL. CDB installed version 12.1.0  PDB or CDB
.1.0.

Database option DV mismatch: PDB installed ve Install or upgrade the database option in the
rsion NULL. CDB installed version 12.1.0.1.0.  PDB or CDB

Database option OLS mismatch: PDB installed v Install or upgrade the database option in the
ersion NULL. CDB installed version 12.1.0.1.0  PDB or CDB
.

Database option ORDIM mismatch: PDB installed Install or upgrade the database option in the
 version NULL. CDB installed version 12.1.0.1  PDB or CDB
.0.

Database option SDO mismatch: PDB installed v Install or upgrade the database option in the
ersion NULL. CDB installed version 12.1.0.1.0  PDB or CDB
.

Database option XOQ mismatch: PDB installed v Install or upgrade the database option in the
ersion NULL. CDB installed version 12.1.0.1.0  PDB or CDB
.

PDB plugged in is a non-CDB, requires noncdb_ Run noncdb_to_pdb.sql.
to_pdb.sql be run.

APEX mismatch: PDB installed version NULL CDB Please contact Oracle Support.
 installed version 4.2.0.00.27

CDB parameter recyclebin mismatch: Previous O Please check the parameter in the current CDB
FF Current on


12 rows selected.

SQL>

When I installed the container database using GUI DBCA, the screen with options was greyed and I had no chance to deselect them.

Oracle docs have the list of what should be compatible between PDBs and the CDBs which include database options, endians, and some other things.

No comments: