Oracle 19c - Jan 2023 CPU patch Invalid XDB objects in a PDB.
Oracle Database Enterprise Edition 19c. Patch from version 19.3 to 19.18 to a multitenant DB using combo patch 34773489 (it includes patch 34765931 and 34786990)
After patched the db and ran datapatch. There are no errors in the log. But when check a pdb, there were invalid objects. I followed some Oracle documents' suggestion to manually recompile them after grant some permissions, like:
grant execute on UTL_FILE to XDB;
grant execute on DBMS_SQL to XDB;
grant execute on DBMS_JOB to XDB;
grant execute on DBMS_STATS to XDB;
grant execute on UTL_RAW to XDB;
...
I got some successfully recompiled, but there are still two package body are INVALID. They are: