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.

1 comment:

andrew smith said...

Checking compatibility of databases beforehand is a good idea rather than getting a crashed system!
Search Oracle jobs in India