Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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

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