Category: Oracle Database General

Oracle Database General

Feb 10

Oracle January 2021 Critical Patch Advisory – PL/SQL detailed changes

Oracle January 2021 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 210119 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 SYS.DBMS_AWR_REPORT_LAYOUT – PACKAGE BODY 12cR1 (BP) SYS.DBMS_SQLPATCH – PACKAGE BODY 12cR1 (BP) SYS.DBMS_SQLPATCH …

Continue reading

Feb 10

Dissecting 210119 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.210119 DB PSU 12.1.0.2 12.1.0.2.210119 DB PSU 12.1.0.2.210119 Exadata Bundle Patch 12.1.0.2.210119 OJVM PSU 12.2.0.1 12.2.0.1.210119 RU 12.2.0.1.210119 OJVM PSU 18 18.13.0 RU …

Continue reading

Jan 24

No more 12.2 Oracle RURs patches after 2021?

As some of you know, every quarter, once Oracle releases it’s Critical Patch Update Advisory, some of us (like myself, Mike Dietrish, Frits Hoogland and some other DBAs around) download some or all the available patches to scan the differences Oracle performed in the database. In my case, I download all the PSUs, BPs, RUs, …

Continue reading

Dec 21

21c Gradual Database Password Rollover brings new backdoor opportunities

Oracle Database 21c introduced the new feature called “Gradual Database Password Rollover”. This allows the database password of the application user to be altered while allowing the older password to remain valid for the time specified by the PASSWORD_ROLLOVER_TIME limit (PROFILE parameter). With this new feature, a password of an application can be changed without having …

Continue reading

Dec 15

Understanding internally how 21c Gradual Database Password Rollover works

Oracle Database 21c introduced the new feature called “Gradual Database Password Rollover“. This allows the database password of the application user to be altered while allowing the older password to remain valid for the time specified by the PASSWORD_ROLLOVER_TIME limit (PROFILE parameter). With this new feature, a password of an application can be changed without having …

Continue reading