After Applying Patch 32545013 There Are A Number Of Invalid Objects
After we applied Patch 32545013 to our 19c database, we had a number of invalid objects. We were able to bring the count down to the following 4 by running utlrp:
SQL> select object_type, object_name, last_ddl_time, created from user_objects where status='INVALID' order by 1,2; OBJECT_TYPE OBJECT_NAME LAST_DDL_ CREATED ----------------------- ------------------------------ --------- --------- PACKAGE BODY DBMS_AUTO_INDEX_INTERNAL 09-SEP-21 18-SEP-20 PACKAGE BODY DBMS_AWR_REPORT_LAYOUT 09-SEP-21 18-SEP-20 PACKAGE BODY DBMS_SQLTUNE_UTIL2 09-SEP-21 18-SEP-20 PACKAGE BODY DBMS_SWRF_REPORT_INTERNAL 09-SEP-21 18-SEP-20 SQL> alter package DBMS_SQLTUNE_UTIL2 compile body; Warning: Package Body altered with compilation errors. SQL> show err Errors for PACKAGE BODY DBMS_SQLTUNE_UTIL2: LINE/COL ERROR -------- ----------------------------------------------------------------- 377/12 PLS-00323: subprogram or cursor 'GET_CLOUD_SERVICE_TYPE' is declared in a package specification and must be defined in the package body 390/12 PLS-00323: subprogram or cursor 'GET_TZ_OFFSET' is declared in a package specification and must be defined in the package body 419/12 PLS-00323: subprogram or cursor 'CHOOSEAWRFORPDB' is declared in a package specification and must be defined in the package body SQL> alter package DBMS_AWR_REPORT_LAYOUT compile body; Warning: Package
0