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 subset of Compute Instances in the same compartment. In my use-case, a Windows and Linux admin group is working together in the same compartment. The first question how to restrict instance actions on level start and stop was easy to…

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 many more, not only the cloud providers. From the technical perspective, a PostgreSQL foreign data wrapper extension (FDW) is used to get data from the specified API, in this case the API from Oracle Cloud Infrastructure. Sure, for Oracle Cloud…

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 demo schema HR is loaded and there is a Unified Auditing Policy which gathers information whenever data from the schema HR are selected. SQL> SELECT parameter, value FROM v$option WHERE parameter = ‘Unified Auditing’; PARAMETER VALUE ——————– ——————– Unified Auditing…

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 the line. But, this is not really an option with over 300 list entries… Method B) – OCI CLI Bulk Delete Based on installed OCI CLI, this is a small script which iterates over all entries of a specific compartment…

Read More

Oracle Cloud Infrastructure – iSCSI Block Volume Attachment – the magic Way

Have you always attached an OCI Block Volume to a Compute Instance? If yes, I assume by console or OCI CLI and then executed manually the iSCSI commands to attach the device on OS level. But wait, here is a magic way to attach the Block Volume – by the Oracle Cloud Agent. Prerequisites Attached Service Gateway in VCN Oracle Cloud Agent software installed on the instance Enable the Block Volume Management plugin Verify Compute Instance disk status Create a Block Volume and attach Block Volume to Compute Instance OCI Tool oci-iscsi-config The OCI CLI method – the expressway If you want to  auto-attach a high-performance block volume (multipath enabled) or a block volume where auto-tune is enabled, these two…

Read More