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

How to export all your Oracle Cloud Infrastructure billing information

As of today (October 2019), there is still no internal capability in Oracle Cloud Infrastructure to export the metadata of all the billing information you have in your OCI to a CSV, JSON or any other file that would allow us to easily import in other tools to create our own graphs. Meanwhile, I have …

Continue reading

OOW 2019 – Scanning Oracle Database for malicious changes

Click to download my OOW 2019 session: Scanning Oracle Database for malicious changes! +1

Dissecting 190716 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 190416 BP, PSU, RU and RUR Dissecting 190115 BP, PSU, RU and RUR Dissecting 181016 BP, PSU, RU and RUR …

Continue reading

Oracle Database Proactive Patch 12.1.0.2.190716 failing with ORA-04068 ORA-04061 ORA-04065

Those days, I was updating some of my lab environments running Oracle Database 12.1.0.2 to the 190716 quarterly update Bundle Patch. However, during the Datapatch execution phase, I was getting some ORA errors. Patch 29496791 apply (pdb CDB$ROOT): SUCCESS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_CDBROOT_2019Jul31_11_55_12.log (no errors) Patch 29496791 apply (pdb PDB$SEED): WITH ERRORS logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/29496791/22993732/29496791_apply_ORCL_PDBSEED_2019Jul31_11_58_00.log (errors) Error at …

Continue reading