Dissecting 210420 BP, PSU, RU and RUR

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases.

The following patches were analysed:

  • 11.2.0.4
    • 11.2.0.4.210420 DB PSU
    • 11.2.0.4.210420 Exadata Bundle Patch
    • 11.2.0.4.210420 OJVM PSU
  • 12.1.0.2
    • 12.1.0.2.210420 DB PSU
    • 12.1.0.2.210420 Exadata Bundle Patch
    • 12.1.0.2.210420 OJVM PSU
  • 12.2.0.1
    • 12.2.0.1.210420 RU
    • 12.2.0.1.210420 OJVM PSU
  • 18
    • 18.14.0 RU
    • 18.13.1 RUR
    • 18.12.2 RUR
    • 18.0.0.0.210420 OJVM
  • 19
    • 19.11.0 RU
    • 19.10.1 RUR
    • 19.9.2 RUR
    • 19.0.0.0.210420 OJVM

To check previous changes, follow the links below:

So what oracle internal objects were changed in April 2021 - 210420?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
12.1.0.2   BP         SYS                            VIEW                     5
12.2.0.1   RU         GSMADMIN_INTERNAL              PACKAGE BODY             3
18.0.0.0   18.12RUR   SYS                            PACKAGE                  2
18.0.0.0   18.12RUR   SYS                            PACKAGE BODY             1
18.0.0.0   18.13RUR   SYS                            PACKAGE                  2
18.0.0.0   18.13RUR   SYS                            PACKAGE BODY             1
18.0.0.0   RU         SYS                            PACKAGE                  2
18.0.0.0   RU         SYS                            PACKAGE BODY             1
18.0.0.0   RU         SYS                            VIEW                     1
19.0.0.0   19.10RUR   GSMADMIN_INTERNAL              PACKAGE                  1
19.0.0.0   19.10RUR   GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   19.10RUR   SYS                            PACKAGE                  3
19.0.0.0   19.10RUR   SYS                            PACKAGE BODY             2
19.0.0.0   19.10RUR   SYS                            PROCEDURE                1
19.0.0.0   19.9RUR    GSMADMIN_INTERNAL              PACKAGE                  1
19.0.0.0   19.9RUR    GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   19.9RUR    SYS                            PACKAGE                  3
19.0.0.0   19.9RUR    SYS                            PACKAGE BODY             3
19.0.0.0   19.9RUR    SYS                            PROCEDURE                1
19.0.0.0   19.9RUR    SYS                            VIEW                     2
19.0.0.0   RU         AUDSYS                         PACKAGE BODY             1
19.0.0.0   RU         CTXSYS                         PACKAGE BODY             4
19.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE                  1
19.0.0.0   RU         GSMADMIN_INTERNAL              PACKAGE BODY             3
19.0.0.0   RU         MDSYS                          PACKAGE                  3
19.0.0.0   RU         MDSYS                          PACKAGE BODY             8
19.0.0.0   RU         MDSYS                          TYPE BODY                2
19.0.0.0   RU         REMOTE_SCHEDULER_AGENT         PROCEDURE                1
19.0.0.0   RU         SYS                            PACKAGE                 12
19.0.0.0   RU         SYS                            PACKAGE BODY            28
19.0.0.0   RU         SYS                            PROCEDURE                3
19.0.0.0   RU         SYS                            TYPE                     6
19.0.0.0   RU         SYS                            TYPE BODY                4
19.0.0.0   RU         SYS                            VIEW                    18
19.0.0.0   RU         XDB                            PACKAGE                  1
19.0.0.0   RU         XDB                            PACKAGE BODY             1

P.S: No internal PL/SQL was modified on 11.2.

And created?

VERSION    PATCH      OWNER                          TYPE                 TOTAL
---------- ---------- ------------------------------ --------------- ----------
19.0.0.0   19.10RUR   SYS                            TYPE                     8
19.0.0.0   RU         SYS                            PACKAGE                  3
19.0.0.0   RU         SYS                            PACKAGE BODY             3
19.0.0.0   RU         SYS                            TYPE                     5
19.0.0.0   RU         SYS                            TYPE BODY                1
19.0.0.0   RU         SYS                            VIEW                     7

P.S: No internal PL/SQL was added on 11.2 / 12.1 / 12.2 / 18.

So which are exactly the objects modified by 210420?

VERSION    PATCH           OWNER                          TYPE            NAME                           ACTION
---------- --------------- ------------------------------ --------------- ------------------------------ ------
12.1.0.2   BP              SYS                            VIEW            DBA_LOGSTDBY_NOT_UNIQUE        MOD
12.1.0.2   BP              SYS                            VIEW            DBA_LOGSTDBY_UNSUPPORTED       MOD
12.1.0.2   BP              SYS                            VIEW            DBA_LOGSTDBY_UNSUPPORTED_TABLE MOD
12.1.0.2   BP              SYS                            VIEW            DBA_ROLLING_UNSUPPORTED        MOD
12.1.0.2   BP              SYS                            VIEW            LOGSTDBY_SUPPORT               MOD
12.2.0.1   RU              GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_CLOUDADMIN            MOD
12.2.0.1   RU              GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_NOPRIV                MOD
12.2.0.1   RU              GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_POOLADMIN             MOD
18.0.0.0   RU              SYS                            VIEW            MON_MODS_V                     MOD
18.0.0.0   RU & 18.13RUR & SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
            18.12RUR
18.0.0.0   RU & 18.13RUR & SYS                            PACKAGE         DBMS_REGISTRY                  MOD
            18.12RUR
18.0.0.0   RU & 18.13RUR & SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
            18.12RUR
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016008$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016012$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016023$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016024$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016207$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016378$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000016899$            NEW
19.0.0.0   19.10RUR        SYS                            TYPE            SYS_YOID0000017005$            NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_APP_CONT_REPORT           NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_IMMUTABLE_TABLE           NEW
19.0.0.0   RU              SYS                            PACKAGE         DBMS_MAINTPLAN                 NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_APP_CONT_REPORT           NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_IMMUTABLE_TABLE           NEW
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_MAINTPLAN                 NEW
19.0.0.0   RU              SYS                            TYPE            KU$_COLLIST_T                  NEW
19.0.0.0   RU              SYS                            TYPE            PLAN_PARAMS                    NEW
19.0.0.0   RU              SYS                            TYPE            SYS_YOID0000073756$            NEW
19.0.0.0   RU              SYS                            TYPE BODY       PLAN_PARAMS                    NEW
19.0.0.0   RU              SYS                            VIEW            ALL_IMMUTABLE_TABLES           NEW
19.0.0.0   RU              SYS                            VIEW            CDB_IMMUTABLE_TABLES           NEW
19.0.0.0   RU              SYS                            VIEW            DBA_IMMUTABLE_TABLES           NEW
19.0.0.0   RU              SYS                            VIEW            DB_NOTIFICATIONS               NEW
19.0.0.0   RU              SYS                            VIEW            DB_NOTIFICATIONS$              NEW
19.0.0.0   RU              SYS                            VIEW            KU$_COLLIST_VIEW               NEW
19.0.0.0   RU              SYS                            VIEW            USER_IMMUTABLE_TABLES          NEW
19.0.0.0   19.9RUR         SYS                            PACKAGE BODY    DBMS_IJOB                      MOD
19.0.0.0   19.9RUR         SYS                            VIEW            DBA_JOBS                       MOD
19.0.0.0   19.9RUR         SYS                            VIEW            DBA_JOBS_RUNNING               MOD
19.0.0.0   RU              AUDSYS                         PACKAGE BODY    DBMS_AUDIT_MGMT                MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    CTX_REPORT                     MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRVPARX                        MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRVRIO                         MOD
19.0.0.0   RU              CTXSYS                         PACKAGE BODY    DRVXTAB                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_GEOR                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_GEOR_AUX                   MOD
19.0.0.0   RU              MDSYS                          PACKAGE         SDO_GEOR_INT                   MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOM                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR_AUX                   MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR_GDAL                  MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_GEOR_INT                   MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_LRS                        MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_META                       MOD
19.0.0.0   RU              MDSYS                          PACKAGE BODY    SDO_UTIL                       MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SDO_RDF_TRIPLE_S               MOD
19.0.0.0   RU              MDSYS                          TYPE BODY       SEMCONTEXTINDEXMETHODS         MOD
19.0.0.0   RU              REMOTE_SCHEDULER_AGENT         PROCEDURE       CHECK_AGENT_VERSION            MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_APP_CONT_ADMIN            MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_BLOCKCHAIN_TABLE          MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_PDB_ALTER_SHARING         MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_REDEFINITION_INTERNAL     MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SODA                      MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SODA_UTIL                 MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_SQLTCB_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_STREAMS_ADM_UTL           MOD
19.0.0.0   RU              SYS                            PACKAGE         DBMS_USER_CERTS                MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_APPLY_ADM_INTERNAL        MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_APP_CONT_ADMIN            MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_AUTO_INDEX_INTERNAL       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_BACKUP_RESTORE            MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_BLOCKCHAIN_TABLE          MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_CAPTURE_ADM_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_LOGMNR_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_PDB_ALTER_SHARING         MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SMB                       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SMB_INTERNAL              MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SODA                      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SODA_UTIL                 MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SPM_INTERNAL              MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLPATCH                  MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTCB_INTERNAL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE                   MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SQLTUNE_INTERNAL          MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STREAMS_ADM_UTL           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STREAMS_ADM_UTL_INVOK     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_STREAMS_DATAPUMP_UTIL     MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SWRF_INTERNAL             MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_SWRF_REPORT_INTERNAL      MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_USER_CERTS                MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_XSTREAM_GG_INTERNAL       MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    DBMS_XSTREAM_UTL_IVK           MOD
19.0.0.0   RU              SYS                            PACKAGE BODY    PRVT_COMPRESSION               MOD
19.0.0.0   RU              SYS                            PROCEDURE       DBMS_FEATURE_REGISTER_ALLFEAT  MOD
19.0.0.0   RU              SYS                            PROCEDURE       LOGMNR$ALWAYSSUPLOG_PROC       MOD
19.0.0.0   RU              SYS                            TYPE            JDOM_T                         MOD
19.0.0.0   RU              SYS                            TYPE            JSON_ELEMENT_T                 MOD
19.0.0.0   RU              SYS                            TYPE            JSON_OBJECT_T                  MOD
19.0.0.0   RU              SYS                            TYPE            JSON_SCALAR_T                  MOD
19.0.0.0   RU              SYS                            TYPE            SODA_COLLECTION_T              MOD
19.0.0.0   RU              SYS                            TYPE            SODA_OPERATION_T               MOD
19.0.0.0   RU              SYS                            TYPE BODY       JDOM_T                         MOD
19.0.0.0   RU              SYS                            TYPE BODY       JSON_ELEMENT_T                 MOD
19.0.0.0   RU              SYS                            TYPE BODY       SODA_COLLECTION_T              MOD
19.0.0.0   RU              SYS                            TYPE BODY       SODA_OPERATION_T               MOD
19.0.0.0   RU              SYS                            VIEW            ALL_BLOCKCHAIN_TABLES          MOD
19.0.0.0   RU              SYS                            VIEW            ALL_SNAPSHOTS                  MOD
19.0.0.0   RU              SYS                            VIEW            AUDIT_UNIFIED_POLICIES         MOD
19.0.0.0   RU              SYS                            VIEW            CDB_AUTO_INDEX_VERIFICATIONS   MOD
19.0.0.0   RU              SYS                            VIEW            CDB_CERTIFICATES               MOD
19.0.0.0   RU              SYS                            VIEW            CDB_SNAPSHOTS                  MOD
19.0.0.0   RU              SYS                            VIEW            DBA_AUTO_INDEX_VERIFICATIONS   MOD
19.0.0.0   RU              SYS                            VIEW            DBA_BLOCKCHAIN_TABLES          MOD
19.0.0.0   RU              SYS                            VIEW            DBA_GOLDENGATE_RULES           MOD
19.0.0.0   RU              SYS                            VIEW            DBA_REFRESH                    MOD
19.0.0.0   RU              SYS                            VIEW            DBA_REFRESH_CHILDREN           MOD
19.0.0.0   RU              SYS                            VIEW            DBA_SNAPSHOTS                  MOD
19.0.0.0   RU              SYS                            VIEW            DBA_SUPPLEMENTAL_LOGGING       MOD
19.0.0.0   RU              SYS                            VIEW            INT$AUDIT_UNIFIED_POLICIES     MOD
19.0.0.0   RU              SYS                            VIEW            USER_BLOCKCHAIN_TABLES         MOD
19.0.0.0   RU              SYS                            VIEW            USER_FLASHBACK_ARCHIVE_TABLES  MOD
19.0.0.0   RU              SYS                            VIEW            USER_SNAPSHOTS                 MOD
19.0.0.0   RU              SYS                            VIEW            _auto_index_log                MOD
19.0.0.0   RU              XDB                            PACKAGE         DBMS_SODA_ADMIN                MOD
19.0.0.0   RU              XDB                            PACKAGE BODY    DBMS_SODA_ADMIN                MOD
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE         DBMS_GSM_UTILITY               MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_DBADMIN               MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_POOLADMIN             MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  GSMADMIN_INTERNAL              PACKAGE BODY    DBMS_GSM_UTILITY               MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE         DBMS_BACKUP_RESTORE            MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE         DBMS_GSM_FIXED                 MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE         DBMS_REGISTRY                  MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE BODY    DBMS_GSM_FIXED                 MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PACKAGE BODY    DBMS_RCVMAN                    MOD
           19.10RUR
19.0.0.0   RU & 19.9RUR &  SYS                            PROCEDURE       EXECASUSERID                   MOD
           19.10RUR

What exactly changed for each?

(click to see detailed line changes)

Useful Links:

Have you enjoyed? Please leave a comment or give a 👍!

1 comments

    • Srini on May 2, 2021 at 10:18
    • Reply

    Hi dear Jorge, I am getting issue while oci360 , pls help,
    Error at 33 line of setup_oci360.sh

Leave a Reply

Your email address will not be published.