Oracle Cloud Infrastructure – Housekeeping, a story about pre-authenticated Object Storage URLs

The year 2022 was ending, time for housekeeping the Oracle Cloud Infrastructure account. And there was an old IAM account in the list, containing the “old” company name and nobody knew where this account was used for. So, we removed it. Some hours later I got a message: Pls can you look; we are not able to run OCI Resource Manager Stacks to ramp up training environments … Cannot load package. The URL might not be valid. Contact the package…

Read More

Oracle Cloud Infrastructure – use the Force of Tags, Luke

Yesterday… … I got a question from a good friend in my company who had this use case in Oracle Cloud Infrastructure – thanks Roli from Lucerne for the input for this blog post, the next “Zwätschgelutz” is offered by me. When several OCI compute instances are available in same compartment, how can a user be restricted to just start and stop one of these machines? I have extended this question: How to restrict users to start and stop a…

Read More

Steampipe.io your Oracle Cloud Infrastructure

Do you know steampipe.io by Turbot? When you search for steampipe.io you will get this answer: “Steampipe is an open-source tool to instantly query your cloud services like AWS, Azure….” And this looks like a perfect match for my Oracle Cloud Infrastructure account. With steampipe.io and simple SQL query syntax, you can gather data from your account like running compute instances, block volume used and so on. The tool supports a large number of vendors like Zoom, Splunk, GitHub and…

Read More

Oracle 19c – How to exclude AUDSYS schema data in a Datapump full export – it’s all about the filter

22.11.2022 – Update with Inputs from Roy Swonger, thank you Roy   Why do we have AUDSYS data in our Oracle Data Pump full export? In a customer project, I was asked why there is always data of schema owner AUDSYS included in an Oracle Data Pump full export. The AUDSYS schema contains Unified Audit Trail Records and therefore the data is included when the feature is enabled. The demo case is a 19.15 Container Database with a PDB. The…

Read More

Oracle Cloud Infrastructure – Vulnerability Scanning Report Deletion – Quick Tip

When I tried to delete and old compartment where VCN, Compute Instances and Co. were already deleted, the action failed because there were old Vulnerability Scanning reports available for hosts and ports. And they need to be deleted first before a compartment can be deleted. The error message with the resource ids: Method A) – click by click Here are the scan reports for tab Hosts. You can delete them one by one when clicking on the dropdown menu of…

Read More