Database Administration (MOSC)

MOSC Banner

Invalid SYS package (SYS.DBMS_Scheduler) in PDB with root CDB container

Product: Oracle 19c

After upgrade and restoring the pluggable database to another container database we have the scheduler package (SYS.DBMS_Scheduler) in an Invalid state only when we view from the pluggable database. Package shows as valid when we view from the Container perspective. WE can successfully compile the package from CDB and it compiles successfully as well.

As we cannot validate/compile the package from the PDB session, how can we get this package to get into a Valid state from a PDB perspective?

Thank you in advance for any suggestions/options you can provide.

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