October 2020 - DBA - Rodrigo Jorge - Oracle Tips and Guides

October 2020 archive

Oct 28

Oracle October 2020 Critical Patch Advisory - PL/SQL detailed changes

By DBA RJ in Database Security, Oracle Database General

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) …

Leave comment

Oct 28

Dissecting 201020 BP, PSU, RU and RUR

By DBA RJ in Database Security, Oracle Database General

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 …

Leave comment

Oct 27

Why you should avoid giving inspect/read all-resources policy in OCI

By DBA RJ in Oracle Cloud

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 …

Leave comment

Oct 22

Get your Tenancy OCID using a single oci-cli command

By DBA RJ in Oracle Cloud

If you need to get your Tenancy OCID to use in some of your scripts, there is no simple oci-cli command that will do it for you. However, using some parameters you can get the raw output: $ oci iam compartment list \ --all \ --compartment-id-in-subtree true \ --access-level ACCESSIBLE \ --include-root \ --raw-output \ …