PDB Restricted Due To SDO Mismatch After Apply/Rollback of RU Pa...

admin

SymptomsAfter applying or rollback of Database Release Update patch such as 19.10,
PDB open in restricted mode due to PDB plug-in violations due to SDO mismatch.

"Database option SDO mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL."
select time,name,cause,status,action,message from PDB_PLUG_IN_VIOLATIONS order by name;

TIME                   NAME            CAUSE         STATUS           ACTION                         MESSAGE
------------------------------ -------------------- -------------------- -------------------- -------------------------------------------------- ----------------------------------------------------------------------------------------------------
19-MAY-21 06.08.42.222817 PM   ORCLPDB            OPTION         PENDING          Fix the database option in the PDB or the CDB     Database option SDO mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL.
19-MAY-21 04.59.25.657376 PM   ORCLPDB            OPTION         RESOLVED          Fix the database option in the PDB or the CDB     Database option XOQ mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
19-MAY-21 06.08.41.731739 PM   PDB$SEED         OPTION         PENDING          Fix the database option in the PDB or the CDB     Database option SDO mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL.
19-MAY-21 04.59.25.222855 PM   PDB$SEED         OPTION         RESOLVED          Fix the database option in the PDB or the CDB     Database option XOQ mismatch: PDB installed version NULL. CDB installed version 19.0.0.0.0.
29-OCT-20 11.19.44.923780 AM   PDB$SEED         SQL Patch         RESOLVED          Call datapatch to install in the PDB or the CDB     '19.3.0.0.0 Release_Update 1904101227' is installed in the CDB but no release updates are
Changes  Apply or rollback Database Release Update 19.10 and above
CauseIn Standard Edition, the status of SDO option in dba_registry is "OPTION OFF".
  SDO   Spatial  OPTION OFF    19.0.0.0.0
After apply or rollback RU, the status becomes "Loading".
  SDO    Spatial  LOADING  19.0.0.0.0
If utlrp.sql is executed only in CDB$ROOT, the SDO option status in CDB$ROOT
changes to "OPTION OFF" but the status in PDB's are still "Loading".
This causes PDB plug-in violations.

"Database option SDO mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL."
Solution Run $ORACLE_HOME/rdbms/admin/utlrp.sql in all PDBs. You can use catcon.pl to do it in CDB and PDB at the same time.
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -l /tmp -v -b utlrp $ORACLE_HOME/rdbms/admin/utlrp.sql