Category: Oracle Database General

Oracle Database General

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

Jan 28

Dissecting 200114 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. To check previous changes, follow the links below: Dissecting 191016 BP, PSU, RU and RUR Dissecting 190716 BP, PSU, RU and RUR Dissecting 190416 BP, PSU, RU and RUR …

Continue reading

Oct 24

Dissecting 191016 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. To check previous changes, follow the links below: Dissecting 190716 BP, PSU, RU and RUR Dissecting 190416 BP, PSU, RU and RUR Dissecting 190115 BP, PSU, RU and RUR …

Continue reading

Oct 21

Datapatch fails with ORA-29516, ORA-00604 and ORA-29532 java.lang.ArrayIndexOutOfBoundsException

Those days, while trying to apply 19.5 RU over a 19c Oracle Database (clean 19.2 installation), the datapatch apply phase was trowing me an error: $ datapatch -verbose SQL Patching tool version 19.5.0.0.0 Production on Mon Oct 21 07:46:31 2019 Copyright (c) 2012, 2019, Oracle. All rights reserved. Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_824_2019_10_21_07_46_31/sqlpatch_invocation.log Connecting …

Continue reading