Oracle Linux Automation Manager 2.0 in the Oracle Cloud – A Story about 10.0.2.0/24

no route to host Since some days I was struggling after an OLAM2 – Oracle Automation Manager 2.0 – setup, to connect to specific hosts. As you can see here in the picture, I was able to execute OLAM2 job templates (Ansible Playbooks) against a host in same subnet in 10.0.1.0/24, but not for the other one in subnet 10.0.2.0/24. The message was always the same: no route to host. But, in OCI basically each subnet has connection to the…

Read More

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