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

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…

Read More

Oracle Cloud Infrastructure – Identity Service Vulnerability – Verify your Accounts NOW!

Today I was called by an allied sales from Oracle Switzerland (thanks Andreas). The main contact of the OCI tenant got an email in case of an identity service vulnerability in the past days. As I am not the main contact but the technical admin, I asked the tenant contact. An indeed, there was a mail arrived at 14th of June which was not forwarded to me. Oracle Security Notification for Oracle Cloud Infrastructure (OCI) Identity Service vulnerability CVE-2022-21503 (Doc…

Read More

AWS Custom Engine Versions for Amazon RDS Custom for Oracle – Sightseeing Tour Part 3/3 – Pricing and personal Thoughts

This is the third and last part of the blog post series about AWS Custom Engine Versions for Amazon RDS Custom for Oracle. The blog post series: Part 1: Gives you an overview about the setup Part 2: About connectivity and what you get from AWS Part 3: My personal opinion about this service and some words about pricing After testing and running AWS RDS Custom for Oracle for a while, it’s time to came to a summary and finish…

Read More