Apr 17

Dissecting 200414 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 analyzed: 11.2.0.4 11.2.0.4.200414 DB PSU 11.2.0.4.200414 Exadata Bundle Patch 11.2.0.4.200414 OJVM PSU 12.1.0.2 12.1.0.2.200414 DB PSU 12.1.0.2.200414 Exadata Bundle Patch 12.1.0.2.200414 OJVM PSU 12.2.0.1 12.2.0.1.200414 …

Continue reading

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

Mar 18

OCI “manage database-family” policy not working

On OCI, sometimes you may want to restrict the capability of a given group to only manage databases in a given compartment. Let’s say your compartment name is NPRD and the group name is DBAs. Usually you would end-up with something like this on your policies: allow group DBAs to manage database-family in compartment NPRD …

Continue reading

Mar 18

Consolidating authentication flow of multiple IDCS’s in a single one

Those days, I was working on a customer that had several Oracle IDCS providers. Two of them for Oracle Cloud at Customer different appliances and one Oracle Cloud Infrastrucure account. There was a requirement to consolidate all users authentication flow on a single IDCS, so there was no need of keeping them all synced across …

Continue reading

Mar 09

New “Tenancy Changes” on OCI360

Today I’m releasing v20.03 of OCI360! Now the tool will also include the “Changes since last execution” section for your Tenancy (section 1g), showing everything that changed since last OCI360 call. For now, the scope is limited to tracking changes in the following objects: Compute Instances Block Volumes Security Lists However, I plan to include …

Continue reading