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 …
Arquivos de março 2020
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 …
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 …
mar 06
Weird ORA-01031: insufficient privileges on DGMGRL
Those days, my production dataguard system suddenly started to receive a weird ORA-01031: insufficient privileges on DGMGRL for any task like "show configuration" or "edit database set state". More weird is that nothing (apparently) was changed on the system. Another troubleshooting saga in my DBA life was about to start.. My broker was configured with …