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> 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.
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:
Post a Comment