Categoria: Oracle Cloud

Oracle Cloud

ORA-28427: cannot create, import or restore unencrypted tablespace: USERS in Oracle Cloud

Those days I was trying to create a database using the "CREATE DATABASE" syntax in a IaaS Compute in Oracle Cloud to build a lab for one of my sessions. SQL> CREATE DATABASE db21c USER SYS IDENTIFIED BY Oracle11__ USER SYSTEM IDENTIFIED BY Oracle11__ EXTENT MANAGEMENT LOCAL UNDO TABLESPACE undotbs1 DEFAULT TEMPORARY TABLESPACE tempts1 DEFAULT …

Continue lendo

Exporting all usage and cost report from your Oracle Cloud at once

To track your tenancy cost and usage reports, Oracle made available from the OCI portal the capability of downloading files that are generate daily and uploaded to the bling storage bucket. However, it lack the feature to download all files at once for a specified timeframe. Note: To enable this, you require some policies in …

Continue lendo

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 lendo

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 lendo

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 lendo