Database Administration (MOSC)

MOSC Banner

19c invalid objects - utlrp.sql doesn't report

edited Mar 13, 2020 1:12PM in Database Administration (MOSC) 7 commentsAnswered ✓

I have invalid objects i19c for sys and system. How to fix it?

running ultrp.sql is successful but the invalid objects remain. utlrp.sql isn't reporting them. Why isn't utlrp.sql reporting them?

Is there another script I can use?

In CDB

select count(*) from dba_objects where owner in ('SYSTEM','SYS'); 

result:

53133

I don't understand why I have invalid objects on a fresh install some patching the was successful

19c database stand alone, single tenant, 19.4.0.0.0

Linux 7

Thanks

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