Category: Oracle Database General

Oracle Database General

Aug 25

ORACHKSUM v20.03 is out!

Today I’m releasing v20.03 of ORACHKSUM! Now the tool was updated with latest MOAT369 API and also received all the July-2020 CPU cycle dictionary updates. For the ones who don’t know what I’m talking about, orachksum is a tool that scans your database for malicious internal code changes (like tampering your DBMS_OUTPUT PL/SQL code), comparing …

Continue reading

Jul 14

OCI Volumes – What happens to Incremental backup when Full is deleted?

Those days, in one of my company mail threads, a colleague stated: “We have tested the restores, when the oldest backup is an incremental and prior full backups have been deleted. It works!” This is a pretty funny scenario. So I’ve decided to do some further investigations to understand what really happens in the background: …

Continue reading

Apr 17

Dissecting 200414 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 analyzed: 11.2.0.4 11.2.0.4.200414 DB PSU 11.2.0.4.200414 Exadata Bundle Patch 11.2.0.4.200414 OJVM PSU 12.1.0.2 12.1.0.2.200414 DB PSU 12.1.0.2.200414 Exadata Bundle Patch 12.1.0.2.200414 OJVM PSU 12.2.0.1 12.2.0.1.200414 …

Continue reading

Apr 17

Oracle April 2020 Critical Patch Advisory – PL/SQL detailed changes

Oracle April 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 200414 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 12.1.0.2 DVSYS.DBMS_MACADM – PACKAGE 12cR1 (BP) DVSYS.DBMS_MACADM – PACKAGE BODY 12cR1 (BP) DVSYS.DBA_DV_PREPROCESSOR_AUTH – …

Continue reading

Jan 30

ORACHKSUM v20.01 is out!

Today I’m releasing v20.01 of ORACHKSUM! Now the tool is also compatible with Oracle Database 19c and any other 11.2.0.4+ DB with the latest Jan-2020 patch applied. For the ones who don’t know what I’m talking about, orachksum is a tool that scans your database for malicious internal code changes (like tampering your DBMS_OUTPUT PL/SQL …

Continue reading