Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center