Last week Oracle released the newest Oracle Database 21c. This is an Innovation release (not long term like 19c) that introduces many cool new features, including also the 20c new features which DB release didn’t happen: Oracle is mindful of the unprecedented economic and business disruption our customers faced in 2020. We decided to not …
Nov 06
Docker on Oracle Linux 8 with no access to the internet (yum error)
Those days, after deploying a brand new Oracle Linux 8 from OCI, I deployed docker-ce on it to install a new Oracle Database based on docker. However, when trying to build the database docker image, I started to receive an strange error that was not happening on Oracle Linux 7. I was receiving an strange error …
Oct 28
Oracle October 2020 Critical Patch Advisory – PL/SQL detailed changes
Oracle October 2020 Critical Patch Advisory changed objects performed by each database patch. For more details and the catalog, check the main post: Dissecting 201020 BP, PSU, RU and RUR What exactly changed for each? (click to see detailed line changes) 11.2.0.4 SYS.DBMS_PDB – PACKAGE BODY 11g (BP) 12.1.0.2 DVSYS.DBMS_MACADM – PACKAGE BODY 12cR1 (PSU) …
Oct 28
Dissecting 201020 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.201020 DB PSU 11.2.0.4.201020 Exadata Bundle Patch 11.2.0.4.201020 OJVM PSU 12.1.0.2 12.1.0.2.201020 DB PSU 12.1.0.2.201020 Exadata Bundle Patch 12.1.0.2.201020 OJVM PSU 12.2.0.1 12.2.0.1.201020 …
Oct 27
Why you should avoid giving inspect/read all-resources policy in OCI
I’ve already seen many cases where a customer needs to give some read-only access on their tenancy to contractors / auditors / non-admin users. The easiest thing to is usually give “read” (or the more restrictive “inspect”) all-resources policy to that user’s group. In this article I will show how a user can use that …






