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 …
Oct 10
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 …
Sep 19
OOW 2019 – Scanning Oracle Database for malicious changes
Click to download my OOW 2019 session: Scanning Oracle Database for malicious changes! +1
Aug 18
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 …
Jul 31
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 …





